An SQL Guide for DBASE IV |
Contents
Introduction | 1 |
Starting dBASE IV and entering statements | 11 |
2 | 17 |
Copyright | |
25 other sections not shown
Common terms and phrases
27 Collins 27 second 44 Baker alphanumeric AMOUNT ASCII Ashton-Tate BIRTH candidate key catalog tables Chapter CHAR column identifier column name command comparison operator condition COUNT CREATE TABLE CREATE VIEW cursor data type date expression dBASE dBASE IV defined DELETE Eltham end result Example Give the number GRANT GROUP BY clause GROUP BY PLAYERNO Inglewood integer intermediate result LEAGUENO memory variable Midhurst number and name numeric expression ORDER BY clause P.PLAYERNO Parmenter PAYMENTNO PEN_DATE PENLTIES table player number PLAYERNO column PLAYERNO FROM GAMES PLAYERNO FROM PLAYERS PLAYERNO IN SELECT PLAYERNO NAME PLAYERS table PLAYERS WHERE PLAYERNO PLAYERS.PLAYERNO primary key privilege processing scalar function SELECT clause SELECT FROM PLAYERNO SELECT PLAYERNO SELECT statement sequence number specified SQL statements SQLDBA statistical function Stratford subquery SUM(AMOUNT SYSKEYS SYSTABLS table identifier table name TBNAME team number TEAMS table UNION SELECT UPDATE statement userid view formula weighted arithmetic mean