I have one table that has column (acct_name_flag) = John Doe
I have sec table that has column (account_name) = Johnathan Doe
How do i do a inner join with ON that uses those two columns.. I've tried using Like.. wild cards.. concat
I won't know the names so i can only go off the column names in my query.
select SystemUser.Email, SystemUser.Name, Substring(SystemUser.Name, 1, instr(SystemUser.Name, ' ')) as 'First Name', reverse(Substring(reverse(SystemUser.Name), 1, instr(reverse(SystemUser.Name), ' '))) as 'Last Name',