I think either one meets the standard. The "as" should be completely
optional.
--Jeffrey Marsh
-----Original Message-----
From: Steve Runyon [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 08, 2000 5:51 AM
To: [EMAIL PROTECTED]
Subject: RE: ANSI SQL
I'm about 99% sure that aliases like this (Oracle
or SQLServer version):
select a.someid, b.somevalue
from tableA a, tableB b
where ...
are ANSI standard. On the other hand, those like
this (Access version):
select a.someid b.somevalue
from tableA as a, tableB as b
where ...
are not.
I took a (very) quick look at the ANSI site
(www.ansi.org), but wasn't able confirm this.
Is this what you were asking or did I totally
miss the point?
Steve Runyon
Senior Developer
onProject.com
"Working Together, Apart"
-----Original Message-----
From: Erik Voldengen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 01, 2000 7:46 PM
To: '[EMAIL PROTECTED]'
Subject: ANSI SQL
Does anyone know if table aliases are ANSI 92 compliant?
----------------------------------------------------------------------------
--
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
----------------------------------------------------------------------------
--
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
