Страница 1 из 1

Выгрузка ТТК

Добавлено: Чт ноя 11, 2021 9:59 am
admin

Код: Выделить всё

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