[Dejan Topalovic]

Hm, nisam siguran da sam ispravno shvatio sta zelis, ali mozda ti ovo moze pomoci?

select cn.* 
from code_names as cn, code_pieces as cp 
where instr(cn.code_name, cp.code_piece) > 0 
and cp.code_piece = 'E13';