Forum ERP XL

Kod: Zaznacz cały

select dt_konto as [Konto] from cdn.roznicekursowe
join cdn.daneobiekty on RKN_ID=DAO_ObiNumer and DAO_ObiTyp in (435)
join cdn.DziennikElem on DEL_GIDNumer=DAO_ObiNumer AND DEL_GIDLp=DAO_ObiLp and DAO_ObiTyp in (432) and DAO_ObiLp<>0
join cdn.dekrety on DEL_GIDNumer=DT_GIDNumer AND DEL_GIDLp=DT_GIDLp
where dt_konto like '7%' and {filtrsql}

Kod: Zaznacz cały

select dt_konto from cdn.roznicekursowe
left join CDN.Zrodla on RKN_Id=ZRO_TrnNumer and Zro_TrnTyp in (435)
left join cdn.dekrety on dt_gidtyp=zro_DTtyp and DT_GIDNumer=ZRO_DTNumer and DT_GIDLp=ZRO_DTLp
where dt_konto  like '7%' and {filtrsql}