Results 1 to 3 of 3

Thread: Sql Problem

  1. #1
    Join Date
    Dec 2003
    Posts
    26

    Question Unanswered: Sql Problem

    DO SOMEBODY KNOW WHAT WRONG WITH THIS SQL?

    SELECT * FROM OE.SALES

    A MESSAGE SAID QUALIFIED TABLE NAMES ARE NOT YET SUPPORTED.

  2. #2
    Join Date
    Nov 2003
    Location
    Mumbai, India
    Posts
    92
    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

  3. #3
    Join Date
    Dec 2003
    Posts
    26
    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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •