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!

Stuck! SQL Join

666354Jun 10 2010 — edited Jun 10 2010

Hi,

I have the following tables, the employee table, and a lookup code table

EmpID Status Maritial
==============
1 FT M
2 PT S

Code description
===========
FT Full Time
PT Part Time
M Married
S Single

I am composing a VIEW that needs to include the following info.
EmpId Status Status_Desc Martial Marital_Desc
==================================
1 FT Full Time M Married
2 PT Part Time S Single

I am stuck on how to join those two tables to get the descriptions.

Oracle10gR2.

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 8 2010

Added on Jun 10 2010

6 comments

1,198 views