2) Microsoft Access
3) Deductor :
; (XML); , .
4) Deductor Studio :
, , , ,
5) Access , /?
() # #
6) . .
7) .
8)
9) , , :
[ ] ,
[ ]
[ ]
[ ] ,
[ ]
10) , :
( ).
WHERE SELECT
: , ,
11) ?
(), , NULL-
() ,
()
()
() NULL-
(), , NULL-
()
12) (50%)
. , .
:
SELECT , SUM() AS
FROM Inner Join ON . =..
GROUP BY
ORDER BY ASC;
|
|
13) ?
(), , NULL-
()
()
()
() ,
, , NULL-
() NULL-
14)
15)
()
()
()
()
()
()
16)
[ ]
[ ]
[ ]
[ ]
[ ]
[ ]
[ ]
[ ]
17) SQL- . HAVING SELECT
( )
18) () SELECT :
GROUP BY 4
WHERE 3
FROM 2
SELECT 1
HAVING 5
ORDER BY 6
19) WINDOWS ODBC
20) , , : WHERE is not null
21) ,
-
-
-
-
22) - .
23) ,
, null- SET NULL
, , CASCADE
, RESTRICT
, SET DEFAULT
, IGNORE
24)
25) , , . .
|
|
26) : ,
27) :
[ ]
[ ]
[ ]
[ ]
[ ]
[ ]
[ ]
[ ] ( 66,67%)
28) Deductor Studio .
, :
[ ] ()
[ ] ()
[ ] (, )
[ ] ( )
[ ] (%)
[ ] (, )
[ ] ()
[ ] ()
[ ] ()
29) :
()
()
()
30) - :
[ ]SQLite
[ ]Microsoft Visual FoxPro
[ ]Microsoft Access
MySQL
Microsoft SQL Server 2008
[ ]Deductor
Oracle Database 11g
31)
32)
2 1 . |
33) "" , , :
[ ]
[ ]
[ ]
[ ]
[ ]
34) , , , .
35) ...
36) Deductor Studio .
37) :