Âòîðíèê, 21 Èþíÿ 2016 ã. 19:46
+ â öèòàòíèê
Êàê ïðàâèëüíî ïèñàòü, òàêèå çàïðîñû?
SELECT id_çàêàç AS ¹, Óñëóãè.Èìÿ_óñëóãà, Êëèåíòû.Ôàìèëèÿ, Êëèåíòû.Èìÿ, Êëèåíòû.Îò÷åñòâî, äàòà_çàêàçà AS Äàòà,
âðåìÿ_çàêàçà AS Âðåìÿ, Ìåíåäæåðû.Ôàìèëèÿ AS Ñîòðóäíèê, Àáîíåìåíò_çàêàç AS [Ïî àáîíåìåíòó],
êîëè÷åñòâî_çàêàç AS Êîëè÷åñòâî, Îïëà÷åíî_Çàêàç AS Îïëà÷åíî, îñòàëîñü_óñëóãè AS îñòàëîñü, Ñêèäêà
FROM Çàêàçû, Óñëóãè, Êëèåíòû, Ìåíåäæåðû
WHERE (Çàêàçû.id_óñëóãà = Óñëóãè.id_óñëóãà AND Çàêàçû.id_êëèåíò = Êëèåíòû.id_êëèåíò
AND Çàêàçû.id_ñîòðóäíèê = Ìåíåäæåðû.id_Ñîòðóäíèê) AND (Óñëóãè.Èìÿ_óñëóãà LIKE 'î%')
íå ðàáîòàåò.
http://www.sql.ru/forum/1219202/sql-zapros-c-where
-
Çàïèñü ïîíðàâèëàñü
-
0
Ïðîöèòèðîâàëè
-
0
Ñîõðàíèëè
-