Column id is ambiguous. Position 124

I ran one query which has join on two, three tables for a new model.
When I wrote the native sql query, I select the PLAY button inside the editor before saving model.
It returned the result.
Then I saved.
On Model page, I clicked on refresh button, query ran and rows were displayed.
But When i did for subsequent times, the query is showing the error mentioned in title.

Please help

Okay any workaround with caching enabled for model ?

If I alias the duplicate column names in select only while creating model so that no column have same name, will it work ?

Should work

1 Like