Join Multiple Tables in Query

Many time it becomes necessary to build complex queries to fetch data from multiple tables. This can be easily done by using Join. To setup Join click on Join Info button.

This will present you with following screen.

ZenDevX Design Studio allows three types of Joins:

1. Inner Join

2. Left Join

3. Right Join

To create a Join first select a Table from drop down select and then select a field from drop down select next to it.

Now select the type of Join you want to use.

Again select a Table from drop down select and then select a field from drop down select next to it. Click on Save button to save the Join.