QUERY - как присоединить одну таблицу к запросу несколько раз?

[RVS]

Цитата:

Сообщение от Music

Можете уточнить, что вы имеете в виду?

У меня так:

        workerCertifier            = queryRun.get(TableNum(HcmWorker));
        workerRatingLevelExaminer  = queryRun.get(TableNum(HcmWorker));

public Common get(tableId table, [int occurrence])

occurrence - The data source to be addressed; optional. The number of the data source with the given table; 1-based. If more than one data source has the same table assigned to it, this (optional) parameter can be used to specify which one is to be addressed. It specifies the number of the data source with the given table. Thus, if the CustTable table is assigned to two data sources, and the second data source is required, this argument should have the value 2.

https://msdn.microsoft.com/en-us/lib...(v=ax.50).aspx

Отсюда имеем :

        workerCertifier            = queryRun.get(TableNum(HcmWorker, 1));
        workerRatingLevelExaminer  = queryRun.get(TableNum(HcmWorker, 2));

Вот как-то так