[misk0]

A nesto kao

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

(ovo je iz glave, moguce da ima kakvih syntax gresaka.