There is no specific query that causes this to occur. Usually, it is just a SELECT with one or more JOIN clauses (and aliased tables).
I have also noticed erratic behavior when using table aliases without the AS keyword, although I don't know if this is related. Sometimes including AS and refreshing suggestions will help.
Usually, I cut the SQL from the Query Window, open a new window, paste the SQL, refresh suggestions and then tooltips will work as expected.