Use the SQL Assist SmartGuide to visually compose an SQL query for a Select bean.
Using the SQL Assist SmartGuide you can:
You must first chose the statement type. Chose the Select Unique button if you want to eliminate any duplicate rows in the result set. Chose the Select button if you want the result set to contain all of the rows that meet your selection criteria, including any duplicate rows.
When you display the SQL query, you can also run it as a test using the SQL Assist SmartGuide. You can also copy the SQL query to the clipboard or save it.
Specifying the tables for an SQL statement
Joining tables
Specifying search conditions
Specifying result columns
Sorting the result set
Remapping data to a different SQL data type
Displaying the SQL statement