Entry tags:

code, sql

Access SQL <> SQL Server SQL
А вы ведалі, што вось такі запыт:

SELECT A.Field, B.Field, C.Field
FROM A LEFT JOIN B ON A.Key=B.Key
       LEFT JOIN C ON A.Key=C.Key

працуе ў SQL Server'ы, але выдае памылку ў Access'ы? Дык ведайце. Лечыцца проста:

FROM (A LEFT JOIN B ON A.Key=B.Key)
       LEFT JOIN C ON A.Key=C.Key

Current mood: recovering from a botched attempt to downgrade an SQL Server-based app to an Access-based one.