|
  
|
||
|
|
||
Once the SQL Data source is active and the query builder is activated there are two ways to create a visual query.
Method 1:
One table objects from the right of the query builder view can be dragged and dropped in the object view;-
Dragging and dropping table objects and then selecting fields builds a query. By default a "Select * from" statement is created. if you then select fields from the table object the query will change top reflect the selection:-
The visual query builder allows for point and click manipulation of the query and creates the SQL code.
Method 2:
The second method is to right click in the upper query builder area and select 'Add Object'
A table dialogue opens allowing the selection of tables and views to build the query.
