Hi all,

I have 3 tables.

I want select data from 1 of the table but and using subquery to select another 2 value from another 2 tables.

actually i want to do a comparison if table A Type = 'E' then select from Table B if Type ='S' select from Table C.

How do I accomplish this ?

Thanks a million!