"david epsom dot com dot au" <david@epsomdotcomdotau> wrote in message
news:44***********************@lon-reader.news.telstra.net...
Has anyone else noticed this?
In A2K, I can write a query like this:
select tbl.* from (select * from tbl)
If given a chance, the A2k query designer will rewrite that into A97
syntax:
select a.* from [select * from tbl]. as a
Given that the query designer won't let you design subqueries, in A2K or
A97, I think that is amusing.
(david)
Yes, I pointed this out to someone only a couple of days ago - see
"InnerJoin + Left Outer Join syntax problem" posted by Doug on 2 March.
However, I was unable to point him to a website which would confirm this is
the syntax which would be used.
I also have dim memories of this actually causing code to fail. I cannot
remember the precise details, but I think there were ad hoc sql statements
created and something used to break if I used one form or the other. The
queries were fairly long and table and field names themselves needed the
surrounding square brackets as they contained spaces - but I can't remember
the precise details.