[wellidy]

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

[eherber]

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.