IBM (relation). , . . . () (). . , - .
, : (, , .), , , . , . , , : , , , . , .
. , . . .
: .
:
dBaseIII Plus dBase IY ( Ashton-Tate), DB2 (IBM), R:BASE (Microrim)
: ( ), HyTech (). , - . -. Oracle 8.x. Oracle 7.x "" .
, . , . , .
, , . - , . , .
. 2.6 () () . INVOICES () (INVNO) (CUSTNO). INVOICE.ITEMS (-) : (INVNO), (GOODS) (QTY). INVOICES INVOICE.ITEMS INVNO.
|
|
. 2.6.
, , . . 2.7 SELECT SQL () () .
( ). . . . .
) SELECT INVOICES.INVNO, CUSTNO, GOODS, QTY FROM INVOICES, INVOICE.ITEMS WHERE INVOICES.INVNO=INVOICE.1TEMS.INVNO; ) SELECT INVNO, CUSTNO, GOODS, QTY FROM INVOICES; |
. 2.7. SQL
. , .
, . , - .
( ), . , . , , . . . .
uniVers. , , Bubba Dasdb.