"Bob Barrows" wrote in
:

you have yet to provide a
single example of a join statement that works in Jet but not in
SQL Server. If you're talking about the different syntax for
update/delete statements rather than the join structures
themselves, then say so and I will drop out of the discussion.

I explained this many posts ago -- I encountered the problem more
than once (it was a couple years ago during a SQL Server upsizing
project, attempting to convert some queries to SQL views, and the
joins in the Jet SQL had to be rewritten to work on SQL Server), but
I can't recall the exact syntax that caused the problem.

It *did* happen and I do recall that it was a problem with the
parens.

But as I said several posts ago, I can't provide the specifics as
they are lost in the mists of time.

If you would like to believe that this never happened to me, then so
be it.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/