issue with mysql query
hi,When I try to write a query pointing to a Mysql database, I get an error message whenever I want to list 2 table fields in a join which share the same column name.
example:
select
a.name as name1,
b.name as name2
FROM
table1 a
join table2 b
Once I click OK to close the EDIT DATASET popup, I get the following popup error message:
Of course if I remove one of the 2 columns, I can run the query successfully.
example:
select
a.name as name1,
b.name as name2
FROM
table1 a
join table2 b
Once I click OK to close the EDIT DATASET popup, I get the following popup error message:
Following Columns are duplicated:name. If you want select duplicated columns, please use expression elements with uniquename and select the element that you want to duplicate.
Of course if I remove one of the 2 columns, I can run the query successfully.
0