Select Add in the SQL page of the Query property editor to make a new SQL specification for a Select bean. This opens the New SQL Specification window.
Selecting the Use SQL Assist SmartGuide radio button is recommended. SQL Assist is a SmartGuide that helps you visually compose an SQL statement.
Selecting the Manually write SQL opens an SQL editor for you to enter an SQL statement.
When you finish, select OK. This opens the SQL Assist SmartGuide or the SQL editor, depending on the radio button selected.
To cancel making a new SQL specification, select Cancel.