|
|
|
|
|
|
|
|
|
|
version 11
If an SQL query is too complex and contains long names that make it difficult to read, it is possible to use aliases in order to improve its readability.
Here is the previous example using two aliases: Act for the ACTORS table and Cit for the CITIES table.
• The initial query in 4D code would be:
• Using SQL code, the above query becomes:
• Using generic SQL commands, the above query becomes:
• Using the QUERY BY SQL command, we are unable to carry out the query above because it is not possible to pass more than one table as the first parameter.
• Using the SQL EXECUTE IMMEDIATE command, the query above becomes:
To test all the above examples, launch the "4D SQL Code Samples" database and go to the main window. You can then choose the query mode and press the Using Aliases button.
|
|
|
|
|
|
|
|
|
|