Use these keys to select choices in the SQL Statement menu.
Ctrl+N |
New. Creates a new statement and adds it to the current SQL Access Module (SAM). |
Ctrl+P |
Open. Opens an existing SQL statement. |
Ctrl+T |
Tables. Lets you select tables and columns from the current database for inclusion in the current SQL statement. |
Ctrl+W |
Where. Creates a WHERE clause. |
Ctrl+J |
Join. Creates a join clause between two selected tables. |
Ctrl+G |
Group by. Creates a GROUP BY clause. |
Ctrl+R |
Order by. Creates an ORDER BY clause |
F6 |
Run. Dynamically runs the current SQL statement. |
Ctrl+V |
Link variables. Link ESL variables with selected output columns or SQL statement input parameters. |