joinning 3 tables

[Weiss]

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!

[sachinjois]

Try something like below.

Select * from

Customer a

Inner join. Orders b on a.Id=b.id

Inner join Custwish on b.id=c.id

Where a.live area=1 and b.delivered='n'