When I drag more than one table into a Brio query, the tables automatically join together with multiple lines. Whats going on?
A301: This is Brio’s ‘Auto join’ setting, where Brio automatically joins columns with the same name. This does not work well with our databases; we have same-named columns in many tables that you do not want to join on (e.g. Extract Datetime). To turn off this setting: While in Query mode, select DataModel and then Data Model Options. On the General tab, uncheck the ‘Auto join tables’ checkbox. This is a preference that is saved with your query, so you need to turn off the setting in all your saved queries, or else the setting will turn on again after you use a query with the Auto join feature turned on.
