SELECT t1.code_pieces1, t1.code_pieces2, t2.code_name FROM tablica2 as t1 JOIN tablica1 as t2 ON t2.code_name LIKE t1.code_pieces1 OR t2.code_name LIKE t1.code_pieces2