If take sample below that used subqueries and if I use field tip by pressing Ctrl+Space or wait after "b." then in the first subquery tips correctly find fields from sampb table but if I do same in next subquery and aliases is the same then tips show fields from sampb table that have same alias as sampc.
select a.*, (select b.id from sampb b where a.subid = b.id) as x, (select b.id from sampc b where a.subid = b.id) as y from sampa a
Detection of fields in subqueries
Please login to leave a reply, or register at first.