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:14:31 CDT