Re: SQL Text

In Oracle it should be:

SELECT col_1 "F.NAME", col_2 "L.NAME", col_3 ADDRESS FROM table_1

Michael Rose
mmrose_at_home.com

• Original Message ----- From: "Nosie" <tekait11_at_bni.co.id> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, September 29, 2000 3:15 AM 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_at_bni.co.id >
Received on Fri Sep 29 2000 - 01:41:25 CDT