SQL

Most of the data delivered by data providers is defined by using SQL stored in the Query property. Sybase ETL supports a modified set of the SQL-92 standard.

If you do not want to get into the details of SQL-92, you can use the built-in Query Designer to draw the query and have the SQL generated for you. If you want to write SQL manually , or copy SQL from existing projects, you can manually specify your SQL for the Query property.