如何使用类似于sql的连接?

I have 2 tables, say table A and table B and I want to perform a join, but the matching condition has to be where a column from A 'is like' a column from B meaning that anything can come before or after the column in B:I have 2 tables, say table A and table B and I