>I have two SQL 2000 tables (in same database) of phone numbers, TableA and TableB both same format.
>
>I want to ADD to TableA any record (phone number) that is in TableB, but not in TableA
>
>Is that an Outer Join? What would be the syntax????
Try following (not tested)
INSERT INTO tablea
SELECT * FROM tableb
WHERE NOT EXISTS ( SELECT * FROM tablea WHERE tablea.phone = tableb.phone)
--sb--