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
You should not include both columns called serviceCode, one is just used for making the link.
mark.lauze Posted new comment
I did not include both in the query columns.
The issue resolved after I refreshed symbols.
Thanks for your quick reply.