need help with multiple insert from select
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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)