display data joining multiple tables when multiple columns have same column name
display data joining multiple tables when multiple columns have same column name
inapp
Posts: 10Questions: 0Answers: 0
Hi ,
I have a scenario where iam joining multiple tables to display data in data table.
Here when i join two tables , both have columns named Description.
But when the data is rendered to the data table both the column display the same data.
i. it display like
First Name Customer Type Age Type
========== =============
Frank Member Member
Ramya Public Public
Brian Member Member
instead of
First Name Customer Type Age Type
========== =============
Frank Member Adult
Ramya Public Adult
Brian Member Senior
Iam fetching the aocolumns and aodefcolumns dynamically from the database and forming the format that needs to be rendered to the data table.
So in this case if i give alias name to columns will it work, or how can i achieve displaying the exact data when two columns from two tables have same column name.
Thanks
Ramya
I have a scenario where iam joining multiple tables to display data in data table.
Here when i join two tables , both have columns named Description.
But when the data is rendered to the data table both the column display the same data.
i. it display like
First Name Customer Type Age Type
========== =============
Frank Member Member
Ramya Public Public
Brian Member Member
instead of
First Name Customer Type Age Type
========== =============
Frank Member Adult
Ramya Public Adult
Brian Member Senior
Iam fetching the aocolumns and aodefcolumns dynamically from the database and forming the format that needs to be rendered to the data table.
So in this case if i give alias name to columns will it work, or how can i achieve displaying the exact data when two columns from two tables have same column name.
Thanks
Ramya
This discussion has been closed.