quote:

---

Originally posted by Undying

Hi,
I have a major problem. I was asked to create a reference table which is exactly the same as the existing reference table in our database in the office. here are the details.

TABLEA TABLEB TABLEC (reference table)
AID ACODE BID BCODE AID BID
1 BACTEC 1 Bdata1 1 4
2 BLAST 2 Bdata2 1 2
3 ASQW 3 Bdata3 2 1
4 MERE 4 Bdata4 3 (NULL)


the script to join this 3 tables is
select
TABLEA.AID as A_ID,
TABLEA.ACODE,
TABLEC.AID as C_AID,
TABLE.CID as C_BID,
TABLEB.BID as B_ID,
TABLEA.BCODE

FROM TABLEA LEFT OUTER JOIN TABLEC
ON(TABLEA.AID = TABLEC.AID (+)) AND

LEFT OUTER JOIN TABLEB
ON(TABLEC.BID = TABLEB.BID (+))
ORDER BY TABLEA.BCODE

******
Now my problem is to query a table which is the same as TABLEC
(TABLED). But joining another table with outer join is not possible
with this kind of table relationship.
TABLED
AID BID
1 4
1 3
3 1
4 (NULL)


Can anybody give me a good solution on how to query with this added table. I must use the new table at all costs. Thanks a lot in advance. It would be very much appreciated if someone can give me a good solution.


I won't lower my standard to raise yours.

---