Table A Table B 1111 1111 2222 4444 3333

Result 1 In A but not in B = 2222,3333 Result 2 In B but not in A = 4444

I need to tag/identify the difference scenarios e.g. adding a column for results 1=extra/2=missing

I'm using this and because it runs all at once I can't identify the different scenarios. SELECT * FROM A AS A WHERE CONCAT(A.c1,A.c2) NOT IN (SELECT CONCAT(B.b1,b.e) FROM B);

How can I separate the SQL to get what I need to identify the extra vs missing values