Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Posts
    1

    Unanswered: Using FIRST N ROWID

    Hi,

    Iīm having problems when i try to use FIRST N ROWID in sql with 2 or more tables.
    Example:

    SELECT FIRST 10 ROWID, a.cod, b.name
    FROM table_1 a, table_2 b
    where a.cod = b.cod

    I get follow error message: Ambiguous column (rowid).

    When i have one table in sql, this work.

    can someone help me?
    tks

  2. #2
    Join Date
    Aug 2002
    Location
    Bonn/Germany
    Posts
    152
    Try this:

    SELECT FIRST 10 a.ROWID, a.cod, b.name
    FROM table_1 a, table_2 b
    where a.cod = b.cod


    You need to specify from which table (a or b) you want
    the rowid column to be retrieved.

    Best regards

    Eric
    --
    IT-Consulting Herber
    WWW: http://www.herber-consulting.de
    Email: eric@herber-consulting.de

    ***********************************************
    Download the IFMX Database-Monitor for free at:
    http://www.herber-consulting.de/BusyBee
    ***********************************************

Posting Permissions

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