Semi Join with 3 tables

[dharmu131983]

Hi,
i have 2 tables A & C but i dont have any column common to join them. so i am using a 2nd table say B from my data base and using that i am joing A and C.
I want only distinct Values from the table A. Column which is used for Joining A and B is havng multiple values in Table C.
can any1 suggest me how to perform semi join with 3 tables so i get ONLY distinct rows from table A.
query is being used for inserting data and a sequence is being used while inserting so i am not able to use "select distinct".here is my Joining condition.


Where EXISTS (
Select 1
from B
where
B.DISPATCH_NUMBER=A.DISP_NO
and
B.SERVICE_SKU like C.SKU_NUMBER||'%')
)
table C is having more then 1 SKU_number for the a DISPATCH_NUMBER of table B so i am getting multiple rows.Please do tell me how to resolve this issue.

[amitpatel66]

Try this way:

 
SELECT * FROM tablea A,(SELECT DISTINCT column3 FROM tablec) C WHERE EXISTS (SELECT 1 FROM B WHERE B.column1 = A.column1 AND 
B.column2 LIKE C.column3||%);