SELECT A.A_ID1,A.A_ID2,A.A_NAME,b.b_name,c.c_namefrom a,B,cwhere A.A_ID1 = B.A_ID1(+)
and A.A_ID2 = B.A_ID2(+)
AND B.B_ID = 1
and A.A_ID1 = C.A_ID1(+)
AND A.A_ID2 = C.A_ID2(+)
AND C.B_ID = 2
and A.A_ID2 = B.A_ID2(+)
AND B.B_ID = 1
and A.A_ID1 = C.A_ID1(+)
AND A.A_ID2 = C.A_ID2(+)
AND C.B_ID = 2
FROM A,B,C
WHERE A.A_ID1 = B.A_ID1(+)
AND A.A_ID2 = B.A_ID2
AND B.B_ID = 1
AND A.A_ID1 = C.A_ID1(+)
AND A.A_ID2 = C.A_ID2
AND C.B_ID = 2