To locate information about this keyword, please select one of the subentries in the list.

Abs ALIAS Aliases Aliases  AS  and IN    AS: and IN ALL ALTER TABLE AND Apollo SQL - Aggregate Functions Apollo SQL - Arithmetic Functions Apollo SQL - Conditional Expressions Apollo SQL - Date and Time Functions Apollo SQL - String Functions ApolloSQL7.DLL APPEND ArcTan AS ASC AUTOINC AVG BETWEEN BLOB boolean BOTH BY CASE CAST CHAR Clause List Clipper Copy Cos COUNT CREATE CREATE TABLE CREATE TABLE Example Creating Fixed Column Headers with the IN() Predicate cross-tab queries    creating cross-tab query Data Definition Language Data Definition Language DDL Data Manipulation Language DML Data types DATE Date and Time Functions DATETIME DAY DDL DDL and DML DELETE DELETE [WHERE] Deploying Apollo SQL Applications DESC Differences in ApolloSQL from TQuery DISTINCT DIV DML DROP DROP INDEX DROP TABLE ELSE ESCAPE Exp Extract ExtraIndexes FALSE Features fixed-column headers    creating FLOAT FOR Format FormatDateTime FormatFloat Frac FROM FULL GROUP GROUP BY GROUP BY [HAVING GROUP BY [HAVING] HAVING HOUR IF IN IN predicate Index indexes indexing Inline Table Definitions INNER INNER JOIN INSERT INSERT INTO [WHERE] VALUES Int INTEGER INTO Introduction IS [NOT] NULL IS NOT NULL IS NULL JOIN KEY LEADING Left Length LIKE Ln Lower MAX MAXOF MERGE MIN MIN Date and Time MINOF MOD MONEY MONTH MSEC Nested Select New in Apollo SQL 7 NOT Now NTX NULL NUMERIC OEMTranslate ON Operators in expressions optimization OptimizeJoin OptimizeWhere OR ORDER ORDER BY Other SQL References OUTER OUTER JOIN Overview Parameterized queries Parameters Pi PIVOT Pos Power PRIMARY Referencing Sub-Directories REINDEX TABLE Reserved Words Reserved Words in Apollo SQL Right Round RoundDec SDE7.DLL SDECDX7.DLL SDENSX7.DLL SDENTX7.DLL SEC SELECT SET SHL SHR Sin SMALLINT Sqr Sqrt STDEV Sub-Query Sub-Select SubString SUM summary data Summary Data Created by the GROUP BY Clause TABLE THEN TIME TO TQuery TRAILING TRANSFORM TRANSFORM. . . PIVOT Trim TRUE Trunc TruncDec UNIQUE UPDATE UPDATE  [SET] [WHERE] Upper Using Cross-tab Queries to Present Summary Data Using TRANSFORM and PIVOT to Create Cross-tab Queries VALUES WHEN WHERE YEAR