Hi,

I tried :

SELECT TBL_MAIN.PRIM1, TBL_A.A, TBL_B.B

FROM TBL_MAIN, TBL_A, TBL_B

WHERE (TBL_MAIN.PRIM1=TBL_A.PRIM1 (+))

AND (TBL_MAIN.PRIM1=TBL_B.PRIM1 (+))

ORDER BY TBL_MAIN.PRIM1

But it resulted as you shown and it became a combination. I believe...