Jump to content
Sign in to follow this  
Weiss

joinning 3 tables

Recommended Posts

Hi. i have 3 tables: orders, customer, custwish. (every table has id prim key, which match the 3 tables, meaning, if a customer has id=20, there's an order with id=20 regarding him and wishid=20 regarding him)

i wanna make a query where ill get all info from these tables  with the following restrictions:

orderid=customerid=custwishid ; livearea(in table customer) =1, delivered(in table orders)= 'n'

how can i do that with inner join? 

thanx!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×