Třídová akce

Kód:

5

Tělo:

select PID.Closing_ID, ICT.ID as ID1, ICT2.ID as ID2 from PDMIssuedDocs PID
join PDMClosings CL on CL.ID = PID.Closing_ID
join PDMIssuedContentTypes ICT on ICT.ID = PID.IssuedContent_ID
left join PDMIssuedContentTypes ICT2 on ICT2.ID = ICT.NumberQueue_ID
where
not (PID.Closing_ID is null) and PID.Closing_ID <> :ClosingOID and 
CL.Docdate$date >= :FirstDate and CL.Docdate$date <= :LastDate

Generated by ABRA Software a.s. 27.10.2021 16:35:05