As always thanks for your help. I’m returning to this topic as I think there’s room for improvement here. The behavior of the auto-complete:
In previous versions of TOAD the JOIN behavior would suggest the join and also provide the ability to select the field list. The JOIN was listed as the first item, and the second item “” would direct you to the field list.
Ideally auto-complete for JOINs would offer:
1.) Suggested join condition based on relationships to other tables already in the query
2.) Ability to select from a field list to enter your own condition.
As it is I can turn off auto-complete and type but then I lose the ability to look up field names. When you’re dealing with a lot of different projects that feature really helps.