SELECT Table1.C1, Table2.C1 FROM Table1, Table2 WHERE Table1.C1 LIKE '%Table2.C1%'