Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Select Query

468585Jan 30 2006 — edited Nov 4 2010
Hi,
I have 2 different tables,both has Emplid as key. Now i need to fetch values from Value1 and Value2 from table 2,by matching emplid in table 1.
I shuld get my out put something like below. Both Emplid and Emailid Shuld be fetched once from table.

Emplid Email ID Value1 Value2
00001 aa@test.com Ab 123
CD 345
DF 455

00002 bb@test.com AA 089
BB 999

Is it possible with select query.

Thanks
Durai

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 6 2006
Added on Jan 30 2006
8 comments
2,196 views