To merge 2 tables into a distinct (no dups) resultset, use UNION:

SELECT MyField1, MyField2

FROM MyTable1

UNION

SELECT MyField1, MyField2

FROM MyTable2

To see if a set of columns is NOTin another table, there are numerous ways:

SELECT * FROM MyTable2 t2

WHERE NOT EXISTS

(

SELECT MyField1, MyField2

FROM MyTable1 t1

WHERE t1.MyField1 = t2.MyField1

AND t1.MyField2 = t2.MyField2

)

-- or

SELECT t2.*

FROM MyTable2

  LEFT JOIN MyTable1 t1

    ON t2.MyField1 = t2.MyField1

    AND t2.MyField2 = t2.MyField2

WHERE t2.MyField1 IS NULL

Is TeraData ANSI standard or a proprietary SQL language for analysis services? I've never heard of MINUS or EXCEPT.

Edited by - jpipes on 08/22/2003 1:03:00 PM