When I try joining two tables that are joined using the same field name in both tables, I get a publishing error.
Example: Table A contains a field called ServiceCode and is the primary key.
Table B also contains a field called Service code and is a foreign key.
When I do this, and attempt to publish, I get a publishing error.
A member of type QueryColumn with name ‘servicecode’ is already defined in Query ‘SOD_ServiceCodes_BG’ by the extension ‘Beltmann Group by MLauze (1.0.0.34)’
hougaard Answered question June 25, 2025
You should not include both columns called serviceCode, one is just used for making the link.
mark.lauze Posted new comment June 26, 2025
I did not include both in the query columns.
The issue resolved after I refreshed symbols.
Thanks for your quick reply.