DELETE FROM listings WHERE companyid IN  
(SELECT companyid FROM listings WHERE subid = '12' 
INTERSECT SELECT companyid FROM listings WHERE subid = '13') 
AND subid = '13'

Is the query I have going so far but it doesn't do exactly what I want it to do.

What I am looking for is, any companyid that is in 13 but not in 12 to be put into 12.

Any help would be appreciated. Thanks.

update listings 
set subid = 12
where companyid  in (select companyid from listings where subid = '13')

Originally Posted by mushget

update listings 
set subid = 12
where companyid  in (select companyid from listings where subid = '13')

Thanks for the reply.

I ran the query, and it didn't work. Keep in mind, I want non duplicate data -

I don't want a list thats in 12 and 13, I just want a list thats in 13 and not in 12 to be put into 12.

thanks for sending me this information it was very helpful