SELECT *
FROM combined_table
JOIN lastname
ON combined_table.Full_name LIKE '% ' || lastname.field1 || ',%'
IAMisJourney.abramjmeister.com
"I AM With You – Every Step of the Journey."
IAMisJourney.abramjmeister.com
"I AM With You – Every Step of the Journey."
SELECT *
FROM combined_table
JOIN lastname
ON combined_table.Full_name LIKE '% ' || lastname.field1 || ',%'