--- gives you list of names that are in TABLEA but  not in 
--  TABLEB.  You can swap TABLEA and TABLEB to find those 
--  that are in TABLEB, but not in TABLEA.
SELECT name FROM TABLEA
EXCEPT 
SELECT name FROM TableB;

-- gives you the list of names that are in both tables.
SELECT name FROM TABLEA
INTERSECT
SELECT name FROM TABLEB;

-- gives you list of names from both table, but only once
-- if the name is in both tables.
SELECT name FROM TABLEA
UNION 
SELECT name FROM TABLEB;

quote:

---

Originally posted by mario_2013

Example ... if you want to compare in Table D customer name 'Anderson' is equal to the customer name in table D. If yes then return the customer name but not write the record

---