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????