SQL select from 2 table
i would like to select some records from 2 tables.
firsttable(fidpaky,firstName,lastName,date);
secondtable(fdis,fname,lname,date)
current sql query(which i using)is "select firstName,lastName,date from firsttable where date ='mm-dd-yy'"
Condions are:-
1.current sql query for selection will not changed.
2.my requirement is in addition to the current sql i need the valus of secondtable
(that is i need the sql "select fname,lname,date from secondtable where date ='mm-dd-yy'"
Can i use union??????
Subject
Written By
Posted
SQL select from 2 table
March 30, 2016 01:26AM
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.