I have a table which has a column called NAME and under it contrain a list of names.
NAME
Ann Pert
Steven Pappas
Mai Xiong
I am trying to join this table to another which contrain a list of names as well but they are in the format of FIRST NAME & LAST NAME in seperate columns
FIRST NAME LAST NAME
ANN PERT
STEVEN PAPPAS
I am trying to do something like:
Select *
FROM TABLE_NAME A, TABLE_NAME B
WHERE A.NAME = B.FIRST_NAME || B.LAST NAME
But because there is a space in between First and Last name in Table A it is not picking it up. So is there a way to remove spaces from || or another method
(I did not uplad a set of the data because this is just a question which seems simple to answer)
Using oracle 10