malcom1985 Posted May 2, 2011 Share Posted May 2, 2011 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? Link to comment https://forums.phpfreaks.com/topic/235361-having-trouble-trying-to-execute-queries/ Share on other sites More sharing options...
fugix Posted May 2, 2011 Share Posted May 2, 2011 what is the code that you have so far? Link to comment https://forums.phpfreaks.com/topic/235361-having-trouble-trying-to-execute-queries/#findComment-1209537 Share on other sites More sharing options...
gizmola Posted May 3, 2011 Share Posted May 3, 2011 There is no way to answer this when we don't know the structure of the tables involved and the relationships between them. Link to comment https://forums.phpfreaks.com/topic/235361-having-trouble-trying-to-execute-queries/#findComment-1209783 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.