Search the Community
Showing results for tags 'inner join syntax'.
Found 1 result
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!