.
. . . 1 2 , 5.3.
 |
. 5.3.
1= {k11, k12 ,k1n}, 2= {k21, k22 ,k2m}
1=2, . .
. 1 . ³ (k1= k2). .
1=2, ᒺ U ,
 |
SQL FROM :
FROM _1 INNER JOIN _2 ON _1._1 _2._2,
1¹2, ᒺ. ᒺ :
1. ;
2. , .
( ) , ). 1 2. 1, ᒺ, 1 FROM
FROM _1 LEFT JOIN _2 ON _1._1 _2._2,
, ᒺ , , :
2. 2 , , :
 |
2 ᒺ, 2 , FROM
FROM _1 RIGHT JOIN _2 ON _1._1 _2._2,
, ᒺ , , :
1. , , , :
|
|
|
 |
2. - , , , , .
 |
璺 FROM.
| c | |
| _1, _2 | , ᒺ. |
| _1, _2 | . , , , . |
| : "=," "<," ">," "<=," ">=," "<>". |
, , INNER JOIN.
LEFT JOIN, RIGHT JOIN INNER JOIN, .
ᒺ.
, SELECT.
ON JOIN, :
SELECT
FROM _1 INNER JOIN _2
ON _1._1 _2._1 AND
ON _1._2 _2._2) OR
ON _1._3 _2._3)];
:
1. , Access .
2. QBE SQL-, .
3. SQL-:
¨ ;
¨ ;
¨ .
6. SQL,
, SQL , SQL. ;
SQL, - (/), ;
SQL, ;
SQL, , .
: SQL , :
¨ ֳ , ;
¨ .
䳿:
1. , <C>, , .
2. , SQL, .
3. :
CREATE TABLE [] ([ ] SINGLE, [] CHAR (50));
CREATE TABLE, . 3.1.
CREATE TABLE (_1 [()]
[NOT NULL] [_1] [, _2 [()]
[NOT NULL] [_2] [,...]] [, CONSTRAINT [,...]])
|
|
|
CREATE TABLE .3.2.
CREATE TABLE .
( , ), . , , ( ). , SQL - :
 |
. ( ) .
Access VB, , .
, (FieldSize).
, (, ).
Visual Basic.
- ᒺ (DAO) Field, SQL Jet, .
, Acces.
| Visual Basic | Type ᒺ Field | SQL | ||
| BINARY (: VARBINARY) | ||||
| Boolean | dbBoolean | BOOLEAN(: BIT, LOGICAL, LOGICAL1, YESNO) | ||
| ( = ) | Byte | dbByte | BYTE(: INTEGER1) | |
| ( = ) | Long | dbLong | COUNTER (: AUTOINCREMENT) | |
| Currency | dbCurrency | CURRENCY(: MONEY) | ||
| / | / | Date | dbDate | ( DATE, TIME, TIMESTAMP) |
| ( = (8 )) | (8 ) | Double | dbDouble | (: FLOAT, FLOAT8, IEEEDOUBLE, NUMBER, NUMERIC) |
| ( = ) | dbGUID | GUID | ||
| ( = ) | Long | dbLong | LONG ((: INT, INTEGER, INTEGER4)) | |
| ᒺ OLE | ᒺ OLE | String | dbLongBinary | LONGBINARY(: GENERAL, OLEOBJECT) |
| String | dbMemo | LONGTEXT (: LONGCHAR, MEMO, NOTE) | ||
| ( = (4 )) | (4 ) | Single | dbSingle | SINGLE(: FLOAT4, IEEESINGLE, REAL) |
| ( = ) | Integer | dbInteger | SHORT | |
| String | dbText | TEXT(: ALPHANUMERIC, CHAR, CHARACTER, STRING, VARCHAR) | ||
| String | dbMemo | LONGTEXT | ||
| Variant | VALUE |
Microsoft Access .
| CREATE TABLE | |
| ALTER TABLE | |
| DROP | , |
| CREATE INDEX | . |
! , , , SQL .
|
|
|
ᒺ ODBC, , Microsoft SQL Server, , .
:
SELECT DISTINCTROW ., .[ ]
FROM ;
CREATE TABLE
([_] integer,
[] text,
[] text,
[] date,
[] text,
[] memo,
CONSTRAINT [1] PRIMARY KEY ([_]));
, (., ,. 5. 1.), . :
SELECT 21.* INTO [ ]
FROM 21;
SELECT...INTO
,
SELECT _1[, _2[,...]] INTO [IN ]
FROM
SELECT...INTO:
| _1; _2 | , . |
| , . . |
, , , , .
:
. ; .
INSERT INTO .
