![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Reported for Version 2.05 » View Incident Report |
![]() |
Reported By: Grzegorz Rewucki Reported On: 7/18/2011 For: Version 2.05 Build 10 |
SELECT T.TytulId, T.Znak, T.Nazwa, 0 AS Zaleglosc, SUM(O.SGL+O.OGL+O.WGL+O.ZGL+O.UGL) AS Realizacja FROM TaxiTyt T LEFT JOIN TaxiOper O ON (O.TytulId = T.TytulId) WHERE (T.Rejestr = 0) GROUP BY TytulId HAVING SUM(O.SGL) > 0 INTERSECT SELECT T.TytulId, T.Znak, T.Nazwa, SUM(P.NG) AS Zaleglosc, 0 AS Realizacja FROM TaxiTyt T LEFT JOIN TaxiPoz P ON (P.TytulId = T.TytulId) WHERE (T.Rejestr = 0) GROUP BY TytulId
This web page was last updated on Tuesday, April 23, 2024 at 08:39 AM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |