Hi all,

I need to compare and match two fields, the data can be in following manner:

first_name/tableA first_name/tableB

Diana R Diana

Diana Diana Rosa

Diana R Diana R

Diana Patrick

My result should find only Diana and Patrick as nonmatch and all other as match.

How should I write the query?

Thanks in advance!!