malcom1985

I hope this post is in the right place, I'm not entirely sure that it is. If it isn't, please move this to the correct place. Hopefully I am in the right place though. I'm trying to figure out exactly how I would get SQL to display the unavailable options on a car within my table. The question in the assignment I have wants to know which options are unavailable on a 93 FORD EXPLORER? (Code, Description, Price), and so far I've tried selecting just those three columns but I'm not sure I'm doing this correctly. So far I have: select Code,Description,Price from Options where not exists (select Make,Year from Vehicle select 'Ford Explorer' from make select 93 from year); But that doesn't exactly work. Could anyone offer some suggestions?