Using FIRST N ROWID

wellidy · #1 (**permalink**) 04-14-03, 15:20

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 · #2 (**permalink**) 04-15-03, 02:55

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.

Internet Services

Web Development

Digital Marketing

Consumer Tech