Подскажите, пожалуйста, почему возникает ошибка
Msg 107, Level 16, State 3, Line 1
The column prefix 'dbo.SC46' does not match with a table name or alias name used in the query.
SELECT
TabJ.DATE_TIME_IDDOC,
TabJ.DOCNO
FROM _1SJOURN As TabJ (NOLOCK)
INNER JOIN DH141 AS TabDoc (NOLOCK) ON (TabDoc.IDDOC = TabJ.IDDOC)
LEFT JOIN dbo.SC46 As Контрагенты (NOLOCK) ON (dbo.SC46.ID = TabJ.SP1208)
LEFT JOIN dbo.SC46 As Комитенты (NOLOCK) ON (dbo.SC46.ID = TabJ.SP1204)
WHERE TabJ.DATE_TIME_IDDOC >= '20151001'
AND TabJ.DATE_TIME_IDDOC < '20151001'
AND TabJ.Closed & 1 = 1
AND TabDoc.SP138 <> 0
AND Комитенты.SP35 = '0707845647'
AND Контрагенты.SP35 <> '0707845647'
Забыла удалить dbo.
В оригинале запрос выглядит так:
SELECT
TabJ.DATE_TIME_IDDOC,
TabJ.DOCNO
FROM _1SJOURN As TabJ (NOLOCK)
INNER JOIN DH141 AS TabDoc (NOLOCK) ON (TabDoc.IDDOC = TabJ.IDDOC)
LEFT JOIN SC46 As Контрагенты (NOLOCK) ON (SC46.ID = TabJ.SP1208)
LEFT JOIN SC46 As Комитенты (NOLOCK) ON (SC46.ID = TabJ.SP1204)
WHERE TabJ.DATE_TIME_IDDOC >= '20151001'
AND TabJ.DATE_TIME_IDDOC < '20151001'
AND TabJ.Closed & 1 = 1
AND TabDoc.SP138 <> 0
AND Комитенты.SP35 = '7707845647'
AND Контрагенты.SP35 <> '7707845647'
