Having trouble trying to execute queries

[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?

[fugix]

what is the code that you have so far?

[gizmola]

There is no way to answer this when we don't know the structure of the tables involved and the relationships between them.