Код: Выделить всё
select
ttk.nomer_calc as nomer,
ttk.date_calc as "DATE",
ttk.fk_bd_tovar prod_id,
product.name prod_name,
product.scancod_main prod_scan,
product.ed_izm_name prod_ei,
ttk.norma_min prod_norma,
c.fk_bd_tovar comp_id,
comp.name comp_name,
comp.scancod_main comp_scan,
comp.ed_izm_name comp_ei,
c.norma comp_norma,
c.procent_poter,
c.netto
from bd_calc ttk
join bd_calc_component c on c.fk_calc=ttk.field_key
join bd_tovar product on product.field_key=ttk.fk_bd_tovar
join bd_tovar comp on comp.field_key=c.fk_bd_tovar
where ttk.valid_flag=1 and ttk.arhive_flag=0
order by 1