gungrave12 Posted February 21, 2010 Share Posted February 21, 2010 Hey guys I Really really need help with an sql query. Apparently I'm missing some big concept and can't figure it out. There are three tables: Customer(cust_num, phone, address) Menu( food_name, food_type, price) Orders( cust_num, food_name, quantity) I need to find the phone number of each customer who ordered some food with food type 'soup' and ordered three hamburgers. So, what I think I should be doing is: Query for customers who have ordered some soup (which I know how to do), then query for customers who have ordered three hamburgers (which I know how to do) and then inner join these two resulting tables. I can't figure out how to inner-join two queries though =/. Is there a better way I should be doing this? Please help me, thank you! Quote Link to comment https://forums.phpfreaks.com/topic/192825-help-constructing-a-query/ Share on other sites More sharing options...
fenway Posted February 23, 2010 Share Posted February 23, 2010 What do you have so far? EXISTS is an option as well. Quote Link to comment https://forums.phpfreaks.com/topic/192825-help-constructing-a-query/#findComment-1016923 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.