Çäðàâñòâóéòå, åñòü çàïðîñ:
SELECT DISTINCT Áàçà.ÈÍÍ, Áàçà.Êîä, Áàçà.ÈÍÍ as íàçâàíèå, "","" as Íàèìåíîâàíèå,"","","","","","","","",""
FROM Áàçà
ORDER BY Áàçà.ÈÍÍ
Union SELECT DISTINCT Áàçà.ÈÍÍ,Áàçà.Êîä, Áàçà.Êîëè÷åñòâîÐàáîòíèêîâ, "","" as Íàèìåíîâàíèå,"","","","","","","","",""
FROM Áàçà
ORDER BY Áàçà.ÈÍÍ
UNION SELECT Áàçà.ÈÍÍ,Áàçà.Êîä, Áàçà.ÍàèìåíîâàíèåÎñíîâíîãîÑðåäñòâà, Áàçà.ÃîäÏðèîáðåòåíèÿ, Áàçà.Ñóììà, Áàçà.ÃîäÈñòå÷åíèÿÑðîêà, Áàçà.ÑðîêÏîëåçíîãîÏîëüçîâàíèÿ, Áàçà.êîëè÷åñòâî, Áàçà.ÏîòðåáíîñòüÍàèìåíîâàíèåÎÑ, Áàçà.Õàðàêòåðèñòèêè, Áàçà.ÏîòðåáíîñòüÊîëè÷åñòâî, Áàçà.Ñòîèìîñòü, Round((Áàçà.ÏîòðåáíîñòüÊîëè÷åñòâî*Áàçà.Ñòîèìîñòü)/1000,3), Áàçà.ÎáîñíîâàíèåÏîòðåáíîñòè
FROM Áàçà
ORDER BY Áàçà.ÈÍÍ
UNION SELECT Áàçà.ÈÍÍ,Áàçà.Êîä, "Èòîãî: ", "", Sum(Áàçà.Ñóììà), "","", Sum(Áàçà.êîëè÷åñòâî), "", "", Sum(Áàçà.ÏîòðåáíîñòüÊîëè÷åñòâî), "", Sum(Round((Áàçà.ÏîòðåáíîñòüÊîëè÷åñòâî*Áàçà.Ñòîèìîñòü)/1000,3)), ""
FROM Áàçà
GROUP BY Áàçà.ÈÍÍ,Áàçà.Êîä;
À êîãäà âûïîëíÿåòñÿ, òî âûäàåò íåïîíÿòíóþ ñîðòèðîâêó. À íåîáõîäèìî:
Ó÷ðåæäåíèå
40 ÷åëîâåê
6377777777 1 ïðèíòåð 5000,00 2005 2007 1
6377777777 1 ÌÔÓ íîâûé**** 1 6600,00 6600,00 Íåîõîäèì
Èòîãî: 5000,00 1 1 6600,00 6600,00
Ïîìîãèòå ñ ñîðòèðîâêîé èëè íóæíî ïîïðàâèòü ñàì çàïðîñ ?
http://www.sql.ru/forum/1099291/zapros-na-obedenenie