insert into tableA (name,JobNumber,wxNumber) select name,JobNumber,wxNumber from tableB where wxNumber not in (select wxNumber from tableA)
insert into tableA (name,JobNumber,wxNumber) select name,JobNumber,wxNumber from tableB where wxNumber not in (select wxNumber from tableA)