create or replace view crec_search as (
select mol.pactive, mol.ctab, mol.code, mol.sinonimo, cmpd.prodcode, cmpd.CORPID, bat.BATCHCODE, bat.bcode
from chemdb_moltable mol
left join compound cmpd on (mol.pactive=cmpd.pactive)
left join batch bat on (cmpd.prodcode=bat.prodcode)
)
;