SQL Access vs Excel different?

[Jim in Spokane]

Anyone know why Access uses a different format than Excel for SQL?

Access SQL View:
SELECT SYSADM_GJ.ID, SYSADM_GJ_DIST.AMOUNT, SYSADM_GJ_DIST.AMOUNT_TYPE,
SYSADM_GJ_DIST.BATCH_ID, SYSADM_GJ_DIST.POSTING_DATE
FROM SYSADM_GJ INNER JOIN SYSADM_GJ_DIST ON SYSADM_GJ.ID =
SYSADM_GJ_DIST.GJ_ID;

Excel SQL View:
SELECT GJ.ID, GJ_DIST.AMOUNT, GJ_DIST.AMOUNT_TYPE, GJ_DIST.BATCH_ID,
GJ_DIST.POSTING_DATE
FROM SYSADM.GJ GJ, SYSADM.GJ_DIST GJ_DIST
WHERE GJ_DIST.CURRENCY_ID = GJ.CURRENCY_ID

Thanks!
Jim

 

[Sylvain Lafontaine]

Your exemple of an Excel SQL View is using the old JOIN syntaxe (as well as
an alias for the table SYSADM.GJ). To my knowledge, both of these syntaxes
should work equally well under both Excel and Access. However, it's quite
possible that Access don't support this old syntaxe anymore; I don't know, I
didn't try it.

Finally, this newsgroup is about Access' ADP projects and SQL-Server and not
about Excel or Access' SQL query language used in MDB files; so you should
ask in a more appropriate newsgroup than this one.

 

[Jim in Spokane]

which group do you suggest?

Your exemple of an Excel SQL View is using the old JOIN syntaxe (as well as
an alias for the table SYSADM.GJ). To my knowledge, both of these syntaxes
should work equally well under both Excel and Access. However, it's quite
possible that Access don't support this old syntaxe anymore; I don't know, I
didn't try it.

Finally, this newsgroup is about Access' ADP projects and SQL-Server and not
about Excel or Access' SQL query language used in MDB files; so you should
ask in a more appropriate newsgroup than this one.

 

[Sylvain Lafontaine]

Maybe m.p.access, m.p.a.queries or even better, a newsgroup about Excel?

 

[Pat Stier]

Jim in Spokane1/31/07 10:12 AM

which group do you suggest?

 

[Pat Stier]

Sylvain Lafontaine1/31/07 9:45 AM