Hi

You will get same result but faster using exists:

select * from TABLE1 T1
where exists (select 1 from TABLE2 T2 where T2.ID1 = T1.TABLE1ID or
T2.ID2=T1.TABLE1ID)

Regards,
Paul

----------------------------------------

Hi,


is it not possible to have something like this:


select * from TABLE1 where TABLE1ID in

(select ID1 from TABLE2 union select ID2 from TABLE2)


cu Christian





















[Non-text portions of this message have been removed]