Viewing post 1 (of 1 total)
If you don't want to join the Film table in, you could add an exists clause to the select:
select Countryid, CountryName
from Country
where exists (
select *
from Film
where Film.CountryID = Country.CountryID
and RunTimeInMinutes...
September 22, 2015 at 5:33 am
#1828335