Join Query solution for multiple table check.
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
Subject
Written By
Posted
Join Query solution for multiple table check.
May 21, 2014 02:22AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.