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? Quote 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? Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.