Drag & Drop Functions
 
Simple SELECT of complete tables or single columns
  1. Select table or column in the database-explorer, hold down left mouse-button and drop table or column on the SQL-editor
  2. Repeat step 1. to add further tables/columns
  3. Press Ctrl-key to add the selected field to the ORDER BY list
  4. Press Shift-key to add the selected field to the GROUP BY list
  5. Press Alt-key to define the WHERE-condition for the selected field
 
JOINS
  1. Perform step 1. and 2. to select tables/columns
  2. INNER JOIN: Select left JOIN-column in the database explorer, hold down left mouse-button and drop it on the right JOIN-column in the database explorer
  3. LEFT OUTER JOIN: Step 7. with pressed Ctrl-key
  4. RIGHT OUTER JOIN: Step 7. with pressed Alt-key
  5. FULL OUTER JOIN: Step 7. with pressed Shift-key
 
SUBSELECTS
  1. Insert a blank character at the position for the SUBSELECT into the SQL-Editor and highlight the blank character
  2. Perform steps 1. to 11. to create the SUBSELECT for the highlighted area.
 
<< Back