I have a problem that I can't seem to solve. What I am trying to do is find unique columns based in table A that doesn't exist in other table B and store them in table B. Something on the lines of
SELECT DISTINCT(A.FNAME), A.LNAME from ADDRESS A WHERE NOT EXIST
(SELECT DISTINCT(B.FNAME),B.LNAME
FROM ADDRESSLIVE B)
but that doesn't seem to work, my ideal logic is to use the FNAME column and LNAME column together as a unique id, since those columns separately can be duplicates. Can someone inform me of what I am doing wrong, or what I am trying to do if its even possible?