Do your "like" columns have data values that match and represent the same things? You can join a table with a "State" column with one with a "ST" column if they both have values like "AL", "AK", etc.
I'm not sure if you're asking a SQL question...