Галактика в вопросах и ответах

Код: Выделить всё

select atl_nrec from X$USERS where XU$LOGINNAME='<имя пользователя>#1' AND XU$USEROFFICE = 1

Код: Выделить всё

sqlAddStr(str_handle,'LEFT JOIN (SELECT * FROM Exclassval) As Exclassval1 ON Npunkts.Nrec = Exclassval1.Crec ');
sqlAddStr(str_handle,'LEFT JOIN (SELECT * FROM ExclassSeg) As ExclassSeg1 ON ExclassVal1.CclassSeg = ExclassSeg1.Nrec ');

Код: Выделить всё

LEFT JOIN (SELECT * FROM Exclassval) As Exclassval1 ON Npunkts.Nrec = Exclassval1.Crec

Код: Выделить всё

LEFT JOIN Exclassval As Exclassval1 ON Npunkts.Nrec = Exclassval1.Crec

Код: Выделить всё

sqlAddStr(str_handle,'SELECT Name, Summa FROM ( ');

         sqlAddStr(str_handle,'SELECT Min(Nrec) As Nrec, Result.Name, SUM(Result.Summa) As Summa FROM ( ');

         sqlAddStr(str_handle,'SELECT MIN(Katorg.Nrec) As Nrec, Katorg.Name, SUM(Basefin.Summa)*(-1) AS Summa  FROM Basefin ');
         sqlAddStr(str_handle,'INNER JOIN Katorg ON Basefin.Corg = Katorg.Nrec ');
         sqlAddStr(str_handle,'WHERE Katorg.Cstate = ? AND Katorg.Corpoin <>1 AND Direct = 1 AND Ddoc >=? AND Ddoc <= ? ');
         sqlAddStr(str_handle,'GROUP BY Katorg.Name ');

         sqlAddStr(str_handle,'UNION ');

         sqlAddStr(str_handle,'SELECT MIN(Katorg.Nrec) As Nrec, Katorg.Name, SUM(Katsopr.Summa) AS Summa FROM Katsopr ');
         sqlAddStr(str_handle,'INNER JOIN Katorg ON Katsopr.Corg = Katorg.Nrec ');
         sqlAddStr(str_handle,'WHERE Katorg.Cstate = ? AND Katorg.Corpoin <>1 AND Tipsopr = 2  AND Dsopr >=? AND Dsopr <= ? ');
         sqlAddStr(str_handle,'GROUP BY Katorg.Name ');

         sqlAddStr(str_handle,'UNION ');

         sqlAddStr(str_handle,'SELECT MIN(Katorg.Nrec) As Nrec, Katorg.Name, SUM(Katsopr.Summa)*(-1) AS Summa FROM Katsopr ');
         sqlAddStr(str_handle,'INNER JOIN Katorg ON Katsopr.Corg = Katorg.Nrec ');
         sqlAddStr(str_handle,'WHERE Katorg.Cstate = ? AND Katorg.Corpoin <>1 AND Tipsopr = 1 AND Katsopr.Vidsopr = 106 AND Katsopr.Vidsopr = 206 AND Dsopr >=? AND Dsopr <= ? ');
         sqlAddStr(str_handle,'GROUP BY Katorg.Name ');


         sqlAddStr(str_handle,') As Result GROUP BY Name ) As Itog ');
         sqlAddStr(str_handle,'WHERE Summa >= 100000 AND itog.Nrec NOT IN ( ');
         sqlAddStr(str_handle,'SELECT Crec FROM Attrval WHERE Attrval.Cattrnam = ? AND Attrval.Wtable = 1418 AND Attrval.Vdouble = 1)');