The SQL Query Options dialog opens. This is where you can build your SQL Query statements.
Each tab represents an SQL Query condition. The following list describes each condition:
|
• |
Select: Determines which fields to transfer. Required.
|
|
• |
Where: One or more conditions that must occur for a record to be transferred.
|
|
• |
Group by: Allows you to separate the result data into more than one group.
|
|
• |
Having: One or more conditions that must occur by each summary record to be transferred.
|
|
• |
Order by: Specifies an order in which to return the rows.
|
|
• |
Join by: Specifies how the data from multiple files is combined.
|
Each clause must be on a separate line. The default SQL query of SELECT * is used when there is no custom SQL query configured.
For example:
SELECT *
WHERE (t1.IMITM = t2.IMITM)