LIKE with wildcard in Query Table

How do I do the like operator in Query Table?

Select A.*, B.* from tableA as A inner join tableB as B on A.column1 like '%' + B.column1 + '%'

The above code doesn't work. but the code below works but it's not generating my expected output.

Select A.*, B.* from tableA as A inner join tableB as B on A.column1 like B.column1

Thanks!