Return
-
Title
How to prevent automatic JOIN relationship between tables in query builder? -
Description
When I drag a table into Query Builder, the table is automaticallyjoined to other tables via primary and foreign keys. I dont want that and it can be time consuming to remove if there are a dozen associations. Is there a way to disable auto-association?
-
Resolution
1. Go to Tools | Options
2. Expand Database and select Query Builder
3. Uncheck Automatically join tables with relationships