I have a question about reading data from mssql DB.
I have a query like this:
select distinct A.c3, B.c4, C.c6
join B on B.c2 = A.c1
join C on C.c5 = A.c1
Table C also has a column named as "c3".
It ran and read data. Cubes were loaded but when I checked SQL log file I saw some strange logs.
The column 'c3' was specified multiple times for 't'.
I found a solution like "not to read data with *". But as you can see here, I gave the table name.
What I understood from the error log is, Board converts the query and read data with "Select *...".
Do you have an idea about how to solve this problem?
Thank you for your help.