I have two tables, one of them has the proper numbers and the other one may be missing some of htem, what I want is to have s statement to check if the number exists on the second table and if it doesn't to insert it, to create a new record for it. Please help !! Any help is greatly appreciated.
Table1 is the source
Table2 is the target where the missing fields will be inserted.