Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Matt McDawell: "Your practical knowledge & experience, supported by your dedication and hard work set new standards. Taking you into account is the best decision our company has made".
Paul Slicky: "I just want to say this has been the fastest, greatest, and most coopertive tool I have ever had. It turned out to be easy to use and very slick. Keep up the good work".

More

Add your opinion

MaxDB Maestro online Help

Prev Return to chapter overview Next

Joining two objects

To associate database objects by two fields, just drag one field from the object list to another. This will set a link between these objects by the selected fields. After you finish dragging, a line will appear between the linked fields. You can view and edit the properties of object association. To do that, set the cursor to the link line. A hint containing the association condition will appear.

 

 

To edit the properties, select the Property item from the popup menu. A dialog window will appear, there you can change the association condition by selecting it from the list (=, >, <, >=, <=, <>).

 

 

Also you can check or uncheck the Include all option for each object included into the association. Click OK to  apply the changes you have made.

 

To remove a link between objects, select the Delete Link item from the popup menu.

 

To delete all the links of an object, click the '-' button next to the object alias. To insert a point to the link line, select the Insert Point item from the popup menu, and the new point will appear. Using the point you can move the link line. It does not cause any changes in the query but makes the diagram performance vivid and the visual building more obvious.

 

 

 



Prev Return to chapter overview Next