Getting "...aliasing disabled" notice, but Query Builder preferences are all disabled. How do enable table aliasing.

[Anonymous]

I've looked everywhere, but I'm sure I'll do a facepalm when some tells me what I'm missing.

[Anu]

You have to close the existing querybuilder window and then you can edit the query builder preferences for auto-alias from the menu-tools-preferences-querybuilder.

[PAscal]

This is appening because you try to add the same table two times (or more) to the same query.
Before to add this table add an alias to the already added one :
- query tree (left part of the query builder)
- expend the "FROM" node to display the already added table
- right click on on the already added table then choose "Edit ..." ans set an alias for it

Youl will be able to add that table to the query without any error message