Re: Difference between Access97 and PostgreSQL - Mailing list pgsql-sql

From Josh Berkus
Subject Re: Difference between Access97 and PostgreSQL
Date
Msg-id web-680650@davinci.ethosmedia.com
Whole thread Raw
In response to Difference between Access97 and PostgreSQL  ("Yan Bai" <annie_job@hotmail.com>)
List pgsql-sql
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 eventhough it does not relate to Postgres ... if you
promisenot to do itagain!  In the future, send this question to a more appropriate list,such as PSQL-ODBC, where they
discussPaotgres & 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 inthe FROM clause.  THe only sub-queries supported
byAccess 97 aresub-queries in the WHERE clause.
 

All the more reason to use PostgreSQL!

-Josh



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


pgsql-sql by date:

Previous
From: "Yan Bai"
Date:
Subject: Difference between Access97 and PostgreSQL
Next
From: pocm@rnl.ist.utl.pt (Paulo J. Matos)
Date:
Subject: Index Management