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