MacSQL 3.0
Product Tour
Query Editor
The Query Editor provides a graphical view of a SELECT query. Where conditions can be nested as part of AND or OR groups. A single table is chosen as the base table, but joins are automatically handled based on relationships that are defined in the Schema Viewer. The query shown in the image above is actually a four-way join (custorder, customer, orderitems, product) but MacSQL hides that complexity from the user.
Power users can manually edit the query in text mode and then switch back to visual mode. Where conditions can also be manually entered to allow conditions not supported by the Query Editor.