Subquery columns suggestions not working properly

[jasminediaconu]

Describe the bug
The columns suggestions for subqueries are not always given properly.

To Reproduce
Steps to reproduce the behavior:

WORKING CASE:

1. Create a sql statement such as:

SELECT * FROM 
    (SELECT sub1.listid, sub1.venuecity FROM 
        (SELECT v.venuecity, l.listid FROM venue v, listing l) sub1 
    ) sub2, users u WHERE u.userid = sub2.venuecity AND u.userid = sub2.listid;

2. When changing '*' with sub2. the column names listid and venuecity are suggested.

INCORRECT CASE:

1. Create a sql statement such as:

SELECT * FROM users u,
    (SELECT sub1.listid, sub1.venuecity FROM 
        (SELECT v.venuecity, l.listid FROM venue v, listing l) sub1 
    ) sub2 WHERE u.userid = sub2.venuecity AND u.userid = sub2.listid;

2. When changing '*' with sub2. the column name listid is suggested, venuecity is not being suggested.

Additional context
It seems like this issue happens when we first add a table in the FROM clause and then a subquery. If we add them the other way around this issue doesn't appear.