duplicate column name 'name' error

[nextchamp-saqib]

[azurre931]

Can this be tagged a "Priority", we can't use Insights currently because of this error. Thank you :)

[nextchamp-saqib]

It only occurs if there's no columns selected (in the middle section) An easy workaround is to select at least one column and then add a join

But I too face it often. will prioritise it

[nextchamp-saqib]

f26ffe5310742c3808dba3a8b851275a5449df34

Not actually fixed, but now it won't break. Now, select * from table_1 inner join table_2 will show only columns from the first table.

select * queries are considered a bad practice, so the only solution was to select only the columns needed. Since it's challenging to fetch columns of the joined tables before building the query, I decided to resolve the blocker instead of finding a solution.

Will get back to this if users expect to see columns from all tables after performing a join.