syarzhuk: Access SQL <> SQL Serv

Дзюндзя (

syarzhuk) wrote,
@ 2005-01-13 10:00:00

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.

Username:		Create an Account Forgot your login or password? Login w/ OpenID
Password:
	Remember Me
	English • Español • Deutsch • Русский…

	exalbanetc 2005-01-14 08:29 am UTC (link)
	hehe. prepare to the long battle. (Reply to this) (Thread)

	syarzhuk 2005-01-14 11:02 am UTC (link)
	No, we gave up and decided to pay exorbitant fees but stay with SQL Server instead (Reply to this) (Parent)