2 of 2 people found this helpful
Tableau will remove the table prefix from the name and be left with col1 and col1 (Which is not allowed)
You need to alias the fields names (With names that aren't "exactly" then same).
select usertest1.col1 as 1_col1, usertest2.col1 as 2_col1, usertest2.col2 from usertest1, usertest2
Worked great, thanks!
and what if you want to left join the tables based on these fields? You can't use alias names, so you are again facing the same issue.
if you alias the columns but you need to use them as common fields to join the tables then it doesn't work. The Alias names (LEFT JOIN ON Alias1=Alias2 )are not identified. So you need to use the original column names (Table1.Samename=Table2.Samename) which returns the original error...