Can anyone provide an example of SQL syntax that would compare
the primary index of one table to another to determine whether or
not a value in one table exists in the other, and if not then
insert it?

TIA.

David Keith