rajeshkr Posted May 21, 2014 Share Posted May 21, 2014 hi, I have six tables each having a column field (order_no), now i want to match that something like this. 1- select order_no from table 1 where order_no != with order_no present in all other six tables. Can any one suggest which join query or which query i should use to achieve this? thanks Quote Link to comment https://forums.phpfreaks.com/topic/288644-join-query-solution-for-multiple-table-check/ Share on other sites More sharing options...
Barand Posted May 22, 2014 Share Posted May 22, 2014 Use LEFT JOINS. Where there is no match you get null values EG SELECT table1.order_no as t1 , table2.order_no as t2 , table3.order_no as t3 FROM table1 LEFT JOIN table2 ON table1.order_no = table2.order_no LEFT JOIN table3 ON table1.order_no = table3.order_no +----+------+------+ | t1 | t2 | t3 | +----+------+------+ | 1 | 1 | 1 | | 2 | NULL | 2 | | 3 | 3 | NULL | +----+------+------+ Quote Link to comment https://forums.phpfreaks.com/topic/288644-join-query-solution-for-multiple-table-check/#findComment-1480508 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.