[hew212]

DO SOMEBODY KNOW WHAT WRONG WITH THIS SQL?

SELECT * FROM OE.SALES

A MESSAGE SAID QUALIFIED TABLE NAMES ARE NOT YET SUPPORTED.

[vpshriyan]

Hi,

Instead Try:
SELECT * FROM sales ;

I feel that "oe" is the owner of sales table. Normally syntax like:
SELECT * FROM oe.sales ;

is suported across all types of databases (nolog, log, ansi), however it is explicitly mentioned under ANSI compliant databases.

Regards,
Shriyan

[hew212]

Originally posted by vpshriyan
Hi,

Instead Try:
SELECT * FROM sales ;

I feel that "oe" is the owner of sales table. Normally syntax like:
SELECT * FROM oe.sales ;

is suported across all types of databases (nolog, log, ansi), however it is explicitly mentioned under ANSI compliant databases.

Regards,
Shriyan

**************************************************
Thank for helping me. However, I had tried before by using
SELECT * FROM sales;
but it said " NO PRIVILAGE FILE"

I tried another file that without a dot ("."), e.g. named OE_SALES, it work. Is the dot (".") affect the SQL statement?