Re: SQL Access vs Excel different?
- From: Pat Stier <pstier@xxxxxxxxxxxx>
- Date: Wed, 31 Jan 2007 22:38:55 -0800
Jim in Spokane1/31/07 10:12 AM
which group do you suggest?
"Sylvain Lafontaine" wrote:
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, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
"Jim in Spokane" <JiminSpokane@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:534D45BA-0B1C-4B00-A8C9-855B4518FA5E@xxxxxxxxxxxxxxxx
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
.
- Prev by Date: Re: Access 2007 ADP and SQL
- Next by Date: Re: SQL Access vs. Excel different?
- Previous by thread: Re: Access 2007 ADP and SQL
- Next by thread: Re: SQL Access vs. Excel different?
- Index(es):
Relevant Pages
|
