General Rule: The SQL syntax used in the ETL SQL Statement panel depends on the SQL used to connect to the Source Object. The SQL statements and syntax used in the ETL SQL Statement panel must work with the SQL syntax used to connect to the associated Source Object.
All columns must be columns from the source tables named in the FROM clause.
ETL+ Extract, Transform and Load (ETL) window. Source panel on the left, ETL SQL Statement panel to the right.
The SQL syntax used in the ETL SQL Statement panel is the dialect of SQL used by the Source Object. For instance, a source object that connects with MySQL will run MySQL’s dialect of SQL in the ETL SQL Statement panel.
ANSI Standard SQL
ANSI Standard SQL is (mostly) %100 Supported by ETL+ with some known exceptions.