SELECT per.full_name "Buyer Name",
pa.START_DATE_ACTIVE "Begin Date",
pa.END_DATE_ACTIVE "End Date",
per.employee_number,
per.email_address,
per.global_name,
per.local_name
FROM po_agents pa,
per_all_people_f per
WHERE 1=1
AND pa.AGENT_ID = per.person_id
AND PER.person_id='1294';
pa.START_DATE_ACTIVE "Begin Date",
pa.END_DATE_ACTIVE "End Date",
per.employee_number,
per.email_address,
per.global_name,
per.local_name
FROM po_agents pa,
per_all_people_f per
WHERE 1=1
AND pa.AGENT_ID = per.person_id
AND PER.person_id='1294';
No comments:
Post a Comment