|
-
help for code to search tables for something not download in a certain country?
how do i get it to show the films not downloaded in spain as for example this query returns inception as it was download by someone in france but it was also downloaded in the spain so how do i get it to check for films only spain has not downloaded and return.
SELECT tbl_movies.movie_id, movie_title, movie_duration, movie_director, tbl_customer.customer_id, country_of_residence
FROM tbl_movies, tbl_customer, tbl_download
WHERE
tbl_movies.movie_id = tbl_download.movie_id AND
tbl_customer.customer_id = tbl_download.customer_id AND
tbl_customer.country_of_residence != 'spain'
this query shows all the movies download when the country of residence isnt 'spain'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|