OraFAQ Forum: SQL & PL/SQL » to get common records

Home » SQL & PL/SQL » SQL & PL/SQL » to get common records (oracle 11g)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

to get common records [message #576916]

Sun, 10 February 2013 12:06

swapnabpnn
Messages: 68
Registered: December 2010

Member

Hi,
I have a situation as follows.
Table1 has 10 columns as col1,col2,col3,col4,...col10
Table2 has 5 columns as col1,col2,...col5.

col3 and col4 are common in both tables.I am trying to get common records from both tables.How can I get them.

Thanks

Report message to a moderator

Re: to get common records [message #576917 is a reply to message #576916]

Sun, 10 February 2013 12:17

BlackSwan
Messages: 20089
Registered: January 2009

Senior Member

SELECT ONE.COL3, TWO.COL4
FROM TABLE1 ONE, TABLE2 TWO
WHERE ....

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator