SQL Commands

You can pass any SQL Commands to your database with Open Command of the Table menu. Some commands are specific to the database used, other are generic. 

Here are some syntactical hints for frequently used commands. You may copy them from this page, paste them into the dialog box of Open Command and modify them there.

DELETE

DELETE removes records from a table permanently.

DELETE 
FROM table
WHERE criteria

UPDATE

UPDATE modifies records of a table permanently.

UPDATE table
SET { field = newvalue}
WHERE criteria;

SELECT

SELECT returns a recordset.

SELECT [ALL | DISTINCT | DISTINCTROW | TOP n [PERCENT] ] { * | table.* | [table.]field1 [AS alias1] [, [table.]field2 [AS alias2] [, ...]]}
FROM table [, ...]
[WHERE... ]
[GROUP BY... ]
[HAVING... ]
[ORDER BY... ]

UNION

UNION returns a recordset that consists of two concatenated recordsets. Without ALL, duplicated recordsets are eliminated.

query1 UNION [ALL] query2