If i need to relate two tables using data relation on a column "col1" out of which,table1 i want to make as parent table contains duplicate entries in "col1" and i want to retrieve all the rows present in table2 having matching rows on "col1" of only ("col1" and "col2") of table2.

Interview Candidate
Mar 29th, 2006
2
1340

First
Prev
Next
Last

Showing Answers 1 - 2 of 2 Answers

vishal sharma

Apr 3rd, 2006

hi dear
make the parent table , of which column you are going to use to retrieve data from second table.
happy coding

vssandilya
Profile Answers by vssandilya Questions by vssandilya

Jun 18th, 2006

select t1.col1, t2.col2 from table1 t1, table2 t2
where
t1.col1 =t2.col1;