Working with Tables
- After a connection is made a list of tables and views appears in the left-hand listbox. Click to expand a table name to see the columns in the table.
- Double-clicking on a table name creates a "SELECT * FROM..." query
- Right-click on a table name and choose"SELECT..." to get a query like "SELECT COL1, COL2, COL3 FROM ..." query
- Double-click on individual column names to add them to the query
- Joins, updates, inserts, etc. must be typed in by hand.