Experienced report developers will notice that the sample database is very simple (only a dozen tables) and that all the fields in the tables have useful names. In practice, it's very common for a database to have many more tables with very complex relationships and that the field names are not descriptive. This is where SQL Commands can help. This section explores the advantages of using SQL Commands to create reports. To take SQL Commands for a test-drive, follow these steps:
Open Notepad and type the following lines of SQL exactly as they appear here:
SELECT 'Customer'.'Customer Name' AS Name, 'Customer'.'City' AS City, 'Orders'.'Order Date' AS OrderDate, 'Orders'.'Order Amount' AS Amount ...