Database View Duplicate column name error

Skip to main content ↑ ↓

Topic: Database View Duplicate column name error (Read 1308 times) previous topic - next topic

Database View Duplicate column name error

January 02, 2020, 03:08:41 AM

I used the query builder to create an SQL query.

After clicking 'Add', Duplicate column name error occurred when both table has the same column name.

Re: Database View Duplicate column name error

Reply #1 – January 02, 2020, 08:27:37 AM

@dcongie‍ remove one of the developerid as they both contain the same data e.g remove d.developerid or p.developerid
2. Or you can add a clause AS to one or both of them, to make them different. e.g "d.developerid AS developeridOne" and "p.developerid AS developeridTwo"

Re: Database View Duplicate column name error

Reply #2 – January 02, 2020, 12:13:59 PM

Thanks!
I will use the AS to make it work.