Select Join

Once you have defined the tables you want to combine in the Tables tab, you can click the Suggested Joins tab:

If Data Access Studio finds a relationship between your tables, it will list it on the Suggested Joins tab. To select a join, highlight the join you would like to use and click Apply Suggested Joins. Depending on the tables, sometimes information in the Suggested Joins may be blank. In this case, click the Actual Joins tab to Define the join manually.