No, that's exactly what I wanted to know.  Thanks, Steve.

> -----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"
> 
> 
------------------------------------------------------------------------------
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.

Reply via email to