Re: THANKS! -> Re: Valid MS Access SQL Syntax (Double JOINtedness)

From: Bob Barrows [MVP] (reb01501_at_NOyahoo.SPAMcom)
Date: 02/26/05 

Date: Sat, 26 Feb 2005 13:27:24 -0500

Don wrote:
> Bob,
>
> Thanks for the comments! Your suggestion worked and I am now
> expanding my knowledge on the topic. As our ultimate goal is to host
> this on a SQL Server, I have had a non-Access mind set (hence my post
> to microsoft.public.sqlserver.programming). So much so I did not
> even think about using the Query Builder!
>
> Will the Access syntax work on SQL Server? It would be annoying to
> have to come back and reconfigure the SQL strings. But I suppose
> sometimes such is life!
>

The nested joins should work, but you should consider that a one-to-one port
from Access to SQL Server will cause you to fail to take advantage of many
performance enhancements available in SQL Server.

Bob Barrows. 

-- 
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Relevant Pages