How to execute "IN" subquery only once

Question

I have a slow SQL Server query:

SELECT Style
FROM Storage
WHERE Style NOT IN (SELECT ValidStyle FROM ValidStyles)

This syntax causes SELECT ValidStyle FROM ValidStyles to execute once for each row of the parent query. How can I rewrite this to run the subquery one time only?

Answer 1

SELECT Style 
FROM Storage s
WHERE NOT EXISTS(SELECT * FROM ValidStyles vs WHERE vs.ValidStyle=s.Style)