Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Processing
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,182 views