MyTetra Share
Делитесь знаниями!
Кол-во начислений за период по кп у контрагента(Не окончен)
Время создания: 10.01.2020 20:34
Раздел: INFO - JOB - rtneo - Работа над задачами
Запись: wwwlir/Tetra/master/base/1578659692rek7x2opzf/text.html на raw.githubusercontent.com

select a from rtneo$Accrual a where a.contractPosition.contragentRealEstate.id in (select r.contragentRealEstate.id from rtneo$RealEstateContainerYard r where r.contragentRealEstate.id = 'b21ce113-dc76-c845-e68b-c0215d92a1dd') order by a.period



select a.contractPosition.contragentRealEstate from rtneo$Accrual a where a.documentNumber = 2403381 and a.contractPosition.contragentRealEstate.id in (select r.contragentRealEstate.id from rtneo$RealEstateContainerYard r where r.contragentRealEstate.id = '471989bb-16f8-cd8c-8cf8-bd274e86ad1b') order by a.period



select a.contractPosition.contragentRealEstate from rtneo$Accrual a join rtneo$RealEstateContainerYard r where a.contractPosition.contragentRealEstate.id = r.contragentRealEstate.id and r.contragentRealEstate.id = '471989bb-16f8-cd8c-8cf8-bd274e86ad1b' !! a.documentNumber = 2403381 and a.contractPosition.contragentRealEstate.id in (select r.contragentRealEstate.id from rtneo$RealEstateContainerYard r where r.contragentRealEstate.id = '471989bb-16f8-cd8c-8cf8-bd274e86ad1b') order by a.period



select r.containerYard.code from rtneo$Accrual a join rtneo$RealEstateContainerYard r where a.contractPosition.contragentRealEstate.id = r.contragentRealEstate.id and a.documentNumber = 2403384 and r.containerYard.code = 38103608 order by a.period

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