Jump to content

Help constructing a query


gungrave12

Recommended Posts

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!

Link to comment
https://forums.phpfreaks.com/topic/192825-help-constructing-a-query/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.