Hi hope you can help. I have 2 tables (table_a and table_b) and I want to insert all values in table_a.id into table_b.idfk only when those values in table_a.id don't already exist in table_b.idfk. That is basically the crux of what I can't achieve, but to complicate it slightly within the same query I also want to add the number 1 into table_b.siteid for each successful row added.

ta very much like.