Use the SQLAssist SmartGuide to visually compose an SQL statement for a Select bean. Using the SQLAssist SmartGuide you can:
When you display the SQL statement, you can also run it as a test using the SQL Assist SmartGuide. You can also copy the SQL statement 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