# Linked Server: Joins in OpenQuery fail

**URL:** <https://community.cdata.com/t/linked-server-joins-in-openquery-fail/317>\
**Category:** Editions\
**Tags:** article, sql-gateway, odbc, linked-server, ssms\
**Created:** [August 7, 2023, 6:13pm UTC](https://community.cdata.com/t/linked-server-joins-in-openquery-fail/317 "2023-08-07T18:13:33Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Luçjano\_Capo](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/lu%C3%A7jano_capo/32/1638_2.png) [@Luçjano\_Capo](https://community.cdata.com/u/Lu%C3%A7jano_Capo)\
**Post date:** [August 7, 2023, 6:13pm UTC](https://community.cdata.com/t/linked-server-joins-in-openquery-fail/317/1 "2023-08-07T18:13:33Z")

</div>

Using OpenQuery throws the “Duplicate column names are not allowed in result sets obtained through OPENQUERY and OPENROWSET. The column name “id” is a duplicate.” error.

This error occurs with every JOIN. The tests I made:

- SELECT \* FROM OPENQUERY ([GOOGLESHEETS], ‘SELECT \* FROM Food\_FoodSales as a, [Employee Sample Data\_Data] as b WHERE a.Region=b.Region’)
- SELECT \* FROM OPENQUERY ([GOOGLESHEETS], ‘SELECT a.id, b.id FROM Food\_FoodSales a LEFT OUTER JOIN [Employee Sample Data\_Data] b ON a.Region=b.Region’)
- SELECT \* FROM OPENQUERY ([GOOGLESHEETS], ‘SELECT a.id, b.id FROM Food\_FoodSales a INNER JOIN [Employee Sample Data\_Data] b ON a.Region=b.Region’)

To fix this issue, you can simply use the standard SQL statement

SELECT \*

FROM [GOOGLESHEETS].[CData GoogleSheets Sys].[GoogleSheets].[Food\_FoodSales] a,

[GOOGLESHEETS].[CData GoogleSheets Sys].[GoogleSheets].[Employee Sample Data\_Data] b

WHERE [a].[Region]=[b].[Region]