Joining two columns from different tables that contain partial characters

Database

Joining two columns from different tables that contain partial characters

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.

 

no luck

Tags (3)
1 REPLY

Re: Joining two columns from different tables that contain partial characters

Spoiler
I need to use this FYI

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',