Table PS_EMPL_TBL has the following structureEMPLID as Key field. EMPLNAMESALARYTable PS_DEPT_TBL has DEPTID as key fieldDEPTNAMEMGRIDI need prompt for EMPLID in PS_EMPL_TBL as MGRID in PS_DEPT_TBL .How do I achieve this.

Showing Answers 1 - 9 of 9 Answers

Tej

  • Feb 15th, 2007
 

Go To Record Field Properties of the DEPT_TBL for MGRID and give PS_EMPL_TBL as the prompt table.

Carrie

  • Aug 25th, 2011
 

join the two tables:
select E.EMPLID
from PS_EMPL_TBL E
, PS_DEPT_TBL D
where D.MGRID = E.EMPLID

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions