"Getting data from multiple sources is not allowed" Error

The 1C:Enterprise developers forum

Pages: 1

Bahrom	#1 People who like this: 0 Yes / 0 No Nov 21, 2025 07:44 PM
Active user Rating: 3 Joined: Apr 2, 2025 Company:	I was creating a report in which I have to join 2 tables, "PersonZkTecoId" and "dbo_ZkTecoAttendance". in a query. See the attached files, please. What is the fix to this error? Attached Files Download Untitled02.png (55.59 KB) Download Untitled01.png (38.2 KB) Edited: Bahrom - Nov 21, 2025 05:46 PM

Aleksandr Biryukov	#2 People who like this: 0 Yes / 0 No Nov 26, 2025 08:53 PM
Administrator Rating: 30 Joined: Oct 3, 2019 Company:	Hello Bahrom, this is a system limitation. A single query can use only one data source. It is not possible to use multiple sources simultaneously — for example, an external data source and data from 1C at the same time.

Bahrom

People who like this: 0 Yes / 0 No

Nov 28, 2025 07:36 AM

Active user

Rating: 3
Joined: Apr 2, 2025
Company:

Thank you Alexandr, After some research I came to the same conclusion either.

I found out following

Quote

In the 1C:Enterprise platform, there is a restriction that prevents simultaneously retrieving data from the main database table and an external data source table in a single query. This means that directly joining (JOIN) data from different sources within one 1C query is impossible.

Reasons and Limitations

Architectural Restriction: The 1C platform processes queries to external data sources differently than its internal tables. It cannot perform join operations (such as a LEFT JOIN) at the DBMS level when tables from different databases are involved.

Use of Temporary Tables: The use of temporary tables is also not permitted when working directly with external data sources in the same query that retrieves data from the main database.

Aleksandr Biryukov	#4 People who like this: 0 Yes / 0 No Nov 28, 2025 10:48 AM
Administrator Rating: 30 Joined: Oct 3, 2019 Company:	Yes, the whole point is that when you use an external data source, the query is physically executed on the source side, whether it’s an MS SQL Server or an Excel file. And of course, in this situation the 1C engine cannot join two tables if they are physically located in different places... This also leads to a limitation on creating temporary tables — we cannot create a temporary table, for example, while reading data from a text file.

Pages: 1

Users browsing this topic (guests: 1, registered: 0, hidden: 0)

Download brochures