• You' d better be more specific. For example if you need all rows from T1 plus some rows of T2 which are some way related to T1 it may be type of

    SELECT f1,..fn FROM T1

    UNION ALL

    SELECT g1, .. gn

    FROM T2

    WHERE EXISTS (SELECT 1 FROM T1 x WHERE x... = T2...)