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

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

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

 

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

 -Ñòàòèñòèêà

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


Ïîïûòêà âûïîëíèòü çàïðîñ, êîòîðûé íå âêëþ÷àåò óêàçàííîå âûðàæåíèå

×åòâåðã, 11 Äåêàáðÿ 2014 ã. 22:29 + â öèòàòíèê
Ïðèâåò, ôîðóì÷àíå. Ñîáñòâåííî ñðàçó ê âîïðîñó. Ìíå íåîáõîäèìî ñóììèðîâàòü êîëè÷åñòâî áàëëîâ ó íåêîòîðîãî ïðåïîäà, íàïðèìåð 4. Çàïðîñ òàêîâ
SELECT Sum(Ð.Êîëè÷åñòâîÁàëëîâ) as Êîëè÷åñòâîÁàëëîâ, Î.Îáðàçîâàíèå, Î.Àòòåñòàöèÿ
FROM Ðåéòèíã as Ð, Ïðåïîäàâàòåëè as Ï, Äèñöèïëèíû as Ä, Îáðàçîâàíèå as Î
WHERE (Ï.ÊîäÏðåïîäàâàòåëÿ = 4) and (Ï.ÊîäÄèñöèïëèíû = Ä.ÊîäÄèñöèïëèíû) and (4 = Ð.ÊîäÏðåïîäàâàòåëÿ) and (4 = Ð.ÊîäÏðåïîäàâàòåëÿ)

È ñëåäîì âûâàëèâàåòñÿ îøèáêà, êîòîðàÿ íà êàðòèíêå. Óáèðàþ ôóíêöèþ - âñ¸ ðàáîòàåò. Íå ó÷èë ÿçûê çàïðîñîâ, âûðó÷àéòå.

http://www.sql.ru/forum/1131921/popytka-vypolnit-zapros-kotoryy-ne-vkluchaet-ukazannoe-vyrazhenie


 

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

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

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

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