Re: Difference between Access97 and PostgreSQL

Annie,

> My question may out of the range of this forum.

Well, yes. But, since I'm a nice guy, I'll answer your question even
though it does not relate to Postgres ... if you promise not to do it
again! In the future, send this question to a more appropriate list,
such as PSQL-ODBC, where they discuss Paotgres & MS Access.

> When I run the following query under postgreSQL and Access2000, it
> works well. But Access97 cannot accept it. I got the error message
> as 'syntax error near FROM', it seems like in Access97, there cannot
> have a subquery after 'FROM'
>
> --------------------------------------------------
> SELECT temp.rating, temp.avgage
> FROM (SELECT s.rating, AVG(s.age) as avgage
> FROM sailors s GROUP BY s.rating) as temp
> --------------------------------------------------
>

You are exactly correct. MS Access 97 does not support sub-queires in
the FROM clause. THe only sub-queries supported by Access 97 are
sub-queries in the WHERE clause.

All the more reason to use PostgreSQL!

-Josh

______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco