SELECT [stud].[no_st], [stud].[fio], [predm].[no_pr], [predm].[naim_pr]
FROM stud, predm
WHERE [stud].[kurs]=[predm].[kurs];
(_, _, ) ;
(_; _, ) ;
(_, _, ___) .
, , . : ( ), , ("" "" ) .
SELECT _ AS no, _ AS nazv, "Bludo" AS Kateg
FROM
UNION
SELECT _ AS no, _ AS nazv, "Product" AS Kateg
FROM
WHERE _ IN (SELECT _ FROM )
ORDER BY nazv;
SELECT _,_ AS , "" AS
FROM
UNION SELECT ._, _ AS , "" AS
FROM ,
WHERE ._ = ._
ORDER BY ;
(_, _, ) ;
(_; _, ) ;
(_, _, ___) .
, 100 200 . "".
SELECT ._, ._
FROM INNER JOIN ( INNER JOIN ON ._ = ._) ON ._ = ._
WHERE ((([]![___]) Between 100 And 200) AND (([]![])=""));
! .
(_, _, ) ;
(_; _, ) ;
(_, _, ___) .
, 100 . , " ".
SELECT [_], [_]
FROM
WHERE (select count(._) from where ._=._) = (select count(._) from , where ._=._ and _="") and (select count(._) from where ._=._ and (.___ <=100 or not exists (select _ from , where ._=._ and _="" and ._=._)))=0;
(, , , ) ;
(, , , , ) ;
(, , ) .
, , . , , . , , - NULL. .
|
|
|
SELECT ., ., .
FROM _x LEFT JOIN _y ON(x.=y.)
WHERE x.<=y.
ORDER BY
(, , , ) ;
(, , , , ) ;
(, , ) .
, , . : (/); (/); (/); ( / ). , .
SELECT DISTINCT ., ., AS , SUM(.qty)
FROM INNER JOIN ON (. = .)
WHERE count(*)>0
GROUP BY (.)
UNION
SELECT ., .. AS , SUM
FROM INNER JOIN ON (. = .)
WHERE count(*)>0
GROUP BY .
ORDER BY
ORDER BY .
(, , , ) ;
(, , , , ) ;
(, , ) .
