Building a "select from where not in" query

[rmarquez5]

Greetings all.

I am trying to write a query much like this:

select [title] from [want list]
where [title] not in
(select [title] from [available movies]);

When I run it, I find it runs SO slow. Is there a better way to find the same results?

Any input would be much appreciated. Hope to hear from you.

R.

 

[Mile-O]

Something like this (may have got the joins the wrong way around i.e. LEFT)

SELECT [Want List].Title
FROM [Want List] RIGHT JOIN [Available Movies] ON [Want List].Title = [Available Movies].Film;

 

[namliam]

1) Yes the is Left

2) you will want to add: Where [Available Movies].Film is null

Regards