SELECT DISTINCT a.text_column
FROM TableA a
LEFT JOIN TableB b ON a.text_column = b.text_column -- LEFT returns all row from TableA...
WHERE b.text_column IS NULL -- ... where there is no matching TableB value
Open in new window
IT issues often require a personalized solution. With Ask the Experts™, submit your questions to our certified professionals and receive unlimited, customized solutions that work for you.