.


:

:



,



( , )

:

































 

 

 

 
FAQ

⇐ 12



- ( )

(, SQL-, ).

  1. ?
  2. ?
  3. ?
  4. (), , .
  5. STUDY?
  6. ?
  7. STUDY?
  8. (, , )?
  9. C Access ?
  10. Microsoft Access?
  11. Access?
  12. C Access?
  13. C Access ?
  14. C Access?
  15. C Access?
  16. ?
  17. , ?
  18. ?
  19. QBE (Query by Example)?
  20. QBE?
  21. ccess?
  22. QBE?
  23. QBE ?
  24. QBE ?
  25. QBE ?
  26. QBE ?
  27. QBE ?
  28. STUDY , .
  29. ?
  30. ?
  31. , ?
  32. Access?

SQL

 

, Access (Structured Query Language SQL). SQL , Access .

SQL . SQL, SQL, Access. SQL Access . Access SQL, / SQL (View/SQL View) .

SQL. SQL, .1. SQL- Access.
SELECT SQL. , ( from ). -SQL-
FROM , , select. SQL- . , (join)
WHERE () . ,
ORDER BY

 

SELECT. ( ) SELECT , , . SELECT , . , . :

 

SELECT _1, _2, _3...

 

_1 .. . , . , , . , . , .

FROM. ( ) FROM ( ), , SELECT. SELECT . , . FROM SELECT, .

 

, FROM , :

 

SELECT ., . FROM ;

 

, FROM :

INNER JOIN... ON

RIGHT JOIN... ON

LEFT JOIN... ON

INNER JOIN... ON . , SQL :

 

SELECT ., .['], ._, .

FROM INNER JOIN ON .= .;

 

, FROM (). INNER JOIN (). , , ON FROM , .

RIGHT JOIN LEFT JOIN , .

WHERE. ( ) WHERE , SELECT FROM, . . WHERE.

 

SELECT ., .

FROM INNER JOIN ON . = .

WHERE .=500;

 

where select, from.

ORDER BY. ( ) ORDER BY . , , ( ) . , .

 

ORDER BY .;

 

⇐ 12


:

: 2017-01-28; !; : 273 |

:

:

, , .
==> ...

1975 - | 1636 -


© 2015-2024 lektsii.org - -

: 0.013 .