SQL Access vs Excel different?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
which group do you suggest?

Sylvain Lafontaine said:
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.
Click to expand...
 
Back
Top