|
|
Posted by Erland Sommarskog on 05/03/06 10:39
jared.pohl@gmail.com (jared.pohl@gmail.com) writes:
> Well its written as you would ANSI SQL but the dateadd function is
> access... noone in the access newsgroup will help at all so i just
> asked here to see if anyone here coul d help.
Just because it's ANSI SQL does not mean that it will compile in any
DB engine. If the Access people does not know their syntax, how could
we know it.
First, try the query only with the FROM clause and the second LEFT JOIN,
to see if that works. If it does, you can rule out that you have an
error with the many parentheses.
Next try this syntax:
SELECT
FROM
LEFT OUTER JOIN
LEFT OUTER JOIN
ON
ON
I have an impression that Access prefers this order, unreadable as it may
be.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|