-Ïîèñê ïî äíåâíèêó

Ïîèñê ñîîáùåíèé â rss_sql_ru_access_programming

 -Ïîäïèñêà ïî e-mail

 

 -Ïîñòîÿííûå ÷èòàòåëè

 -Ñòàòèñòèêà

Ñòàòèñòèêà LiveInternet.ru: ïîêàçàíî êîëè÷åñòâî õèòîâ è ïîñåòèòåëåé
Ñîçäàí: 16.03.2006
Çàïèñåé:
Êîììåíòàðèåâ:
Íàïèñàíî: 4


SQL Çàïðîñ c WHERE

Âòîðíèê, 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


 

Äîáàâèòü êîììåíòàðèé:
Òåêñò êîììåíòàðèÿ: ñìàéëèêè

Ïðîâåðêà îðôîãðàôèè: (íàéòè îøèáêè)

Ïðèêðåïèòü êàðòèíêó:

 Ïåðåâîäèòü URL â ññûëêó
 Ïîäïèñàòüñÿ íà êîììåíòàðèè
 Ïîäïèñàòü êàðòèíêó