MyTetra Share
Делитесь знаниями!
CRE+CY
Время создания: 25.08.2020 10:35
Раздел: INFO - JOB - rtneo - Выгрузки
Запись: wwwlir/Tetra/master/base/1598322937f80rsbo7rr/text.html на raw.githubusercontent.com

select distinct r.contragentRealEstate.id, r.contragentRealEstate.realEstate.address, r.contragentRealEstate.realEstate.cadastralNumber, r.contragentRealEstate.realEstate.area, r.contragentRealEstate.category.name, r.contragentRealEstate.calculationAmount, r.containerYard.code, (select sum(cw.count) from rtneo$ContainerWaste cw where cw.containerYard = r.containerYard), (select sum(cw.type.volume*cw.count) from rtneo$ContainerWaste cw where cw.containerYard = r.containerYard), r.containerYard.fixedExportSchedule from rtneo$Contragent c join rtneo$Payment p on c.inn = p.inn join rtneo$RealEstateContainerYard r on c.id = r.contragentRealEstate.contragent.id where c.personalAccount = 'ААА3812014066' order by r.contragentRealEstate.realEstate.cadastralNumber

Так же в этом разделе:
 
MyTetra Share v.0.55
Яндекс индекс цитирования