Message-Id: <10634.118210@fatcity.com> From: Paul van Dijken Date: Fri, 29 Sep 2000 12:27:39 +0200 Subject: RE: SQL Text Why would you want to use a dot in an alias ? I can see why you need the dot in the original name ("Select a.col_1, b.col_2 from AA a, BB b;") Paul -----Original Message----- From: Nosie [mailto:tekait11@bni.co.id] Sent: 29 September 2000 08:15 To: Oracle Mailinglist; Oracle Lazy DBA; Oracle fatcity Subject: SQL Text Dear All, I develop VB6 application with Oracle8i and ADO connection. The SQL text need to use dot puntuation for column name alias, such as in: "SELECT col_1 F.NAME, col_2 L.NAME, col_3 ADDRESS FROM table_1" Such text produce an error message "missing FROM keyword" of VB or ODBC(?). How and why ??? from Oracle database viewpoint???? Thanks a lot in advance Sincerely, Nosie < tekait11@bni.co.id > -------- If you're bored, then visit the list's website: http://www.lazydba.com (updated daily) to unsubscribe, send a blank email to oracledba-unsubscribe@quickdoc.co.uk to subscribe send a blank email to oracledba-subscribe@quickdoc.co.uk