rss sql ru access programming
rss_sql_ru_access_programming

 -

rss_sql_ru_access_programming

 - e-mail

 

 -

LiveInternet.ru:
: 16.03.2006
:
:
: 4

:

, 25 2018 . 09:33 +

, , .
.
, ( ) , , ,
, .
:
+
SELECT .[], ., ., .[ ], ._, ql3.pub_ball, Q4.mono_ball, q5.pat_ball, q6.rukv_ball, .[ ] AS LabNo, .[ ] AS LabShef, Q_itog.Itogo_bal
FROM ( RIGHT JOIN ((((( RIGHT JOIN  ON . = .) LEFT JOIN (SELECT __. AS Mag, __. & ", " & __._volume & ", " &
 IIf((__._Issue<>0),"(" & __._Issue & ") "," ") & __.[ ] & "-" & __.[ ] AS AllAboutPub, __. AS pub_ball, _. FROM __ 
INNER JOIN _ ON __. = _._ WHERE (__.____ Between ItDateEnd() And ItDateStart()))  AS ql3 ON .[] = ql3.) LEFT JOIN (SELECT Monograf_spisok.AutorId, Monograf.Nazvanie & ", (" & Monograf.KolvoStran & ") " & Format(Monograf.DataPub,"yyyy") AS all_mon, Monograf.ball AS mono_ball FROM Monograf INNER JOIN Monograf_spisok ON Monograf.ID = Monograf_spisok.MonoId WHERE 
(Monograf.DataPub Between ItDateEnd() And ItDateStart()))  AS Q4 ON .[] = Q4.AutorId) LEFT JOIN (SELECT Patent_spisok.AutorId, Patent.Nomer AS all_pat, Patent.Ball AS pat_ball FROM Patent INNER JOIN Patent_spisok ON Patent.ID = Patent_spisok.PatentId 
WHERE (Patent.DataPubl Between ItDateEnd() And ItDateStart()))  AS q5 ON .[] = q5.AutorId) LEFT JOIN (SELECT Rukovod.RukovId, Rukovod.Nazvanie & ", " & Rukovod.Autor & ", " & Rukovod_ql.Level AS all_ruk, Rukovod.ball AS rukv_ball FROM Rukovod_ql INNER JOIN Rukovod ON Rukovod_ql.ID = Rukovod.QualLevel WHERE (Rukovod.DataZashit Between ItDateEnd() And ItDateStart()))  AS q6 ON .[] = q6.RukovId) ON .[ ] = .[ ]) LEFT JOIN Q_itog ON .[] = Q_itog.[]
ORDER BY .[];

http://www.sql.ru/forum/1291470/slozhnaya-vyborka-dannyh-iz-ryada-raznyh-tablic-dlya-otcheta


— — : [1] []
 

:
: 

: ( )

:

  URL