SELECT GA.AWARD_ID , GA.AWARD_NUMBER , GA.AWARD_SHORT_NAME , GP.AWARD_ROLE , PF.PERSON_ID , PF.FULL_NAME , GA.ORG_ID FROM GMS_AWARDS GA , GMS_PERSONNEL GP , PER_PEOPLE_F PF WHERE GA.AWARD_ID = GP.AWARD_ID AND GP.PERSON_ID = PF.PERSON_ID
SELECT GA.AWARD_ID
, GA.AWARD_NUMBER
, GA.AWARD_SHORT_NAME
, GP.AWARD_ROLE
, PF.PERSON_ID
, PF.FULL_NAME
, GA.ORG_ID
FROM GMS_AWARDS GA
, GMS_PERSONNEL GP
, PER_PEOPLE_F PF
WHERE GA.AWARD_ID = GP.AWARD_ID
AND GP.PERSON_ID = PF.PERSON_ID
|
|
|