|Home Quick Tour FAQ Forum Download|
and create a new data model. Press New and enter "Tutorial" as the name for the new model.
Create a new connection.
Select the DBMS you are using from the displayed
list, and fill out the following form:
Add the definitions manually (Add-Button under Associations):
The data model is now complete.
Select the menu item "New Table Browser" from "File" and choose
"EMPLOYEE" as the table you want to browse:
A Table Browser appears showing the rows of table EMPLOYEE.
Select the "Children" item from the "Related Rows" drop-down menu and
choose "EMPLOYEE on inverse-BOSS".
Another Table Browser appears showing the subordinates of each Employee (the inverse of the "BOSS" relationship)
6. Generate SQL-QueryWithin each table browser, a SQL-Query can be generated which selects exactly the browser's content.
Essentially it's a join of all the tables in the navigation chain.
Close the second "EMPLOYEE" browser, navigate from EMPLOYEE to PROJECT_PARTICIPATION, and from there to PROJECT.
Choose "Query Builder" item from the "SQL/Query" menu in the "PROJECT" browser: