finance_teacher
asked on
ORACLE -- JOIN "select" ?
How can I change the below
so it also extracts "ai.ID" ?
select si.ID, si.INFOTYPE, si.INFODATA1, si.INFODATA2 --, ai.ID
from GML_SUPPINFO si
where si.ID IN
(
SELECT ai.INFO_ID
FROM GML_ACCTINFO ai,
GML_ACCTMSTR am
WHERE ai.AM_ID = am.ID
AND am.id = :vVendorID
)
-------------------------- ---------- ----------
Oracle 10g tables attached.
Notes:
GML_ACCTMSTR.ID links to GML_ACCTINFO.AM_ID
GML_ACCTINFO.INFO_ID links to GML_SUPPINFO.ID
tables.txt
so it also extracts "ai.ID" ?
select si.ID, si.INFOTYPE, si.INFODATA1, si.INFODATA2 --, ai.ID
from GML_SUPPINFO si
where si.ID IN
(
SELECT ai.INFO_ID
FROM GML_ACCTINFO ai,
GML_ACCTMSTR am
WHERE ai.AM_ID = am.ID
AND am.id = :vVendorID
)
--------------------------
Oracle 10g tables attached.
Notes:
GML_ACCTMSTR.ID links to GML_ACCTINFO.AM_ID
GML_ACCTINFO.INFO_ID links to GML_SUPPINFO.ID
tables.txt
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
select si.ID, si.INFOTYPE, si.INFODATA1, si.INFODATA2 , AA.ID
from GML_SUPPINFO si
INNER JOIN (
SELECT ai.INFO_ID, ai.ID
FROM GML_ACCTINFO ai,
GML_ACCTMSTR am
WHERE ai.AM_ID = am.ID
AND am.id = :vVendorID
) AA
ON si.ID = AA.INFO_ID