Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to get rid of ROWID in Join query -- ORA-00918: column ambiguously defined

246553May 16 2002
Hi, All

the source of my data block is from two tables Emp and Title. My select statements is:
select a.name, b.title, b.start_date, b.end_date from Emp a, Title b where a.id = b.emp_id

But at run time, I got "ORA-00918: column ambiguously defined"

the wrapped statement becomes:

SELECT ROWID,a.name, b.title, b.start_date, b.end_date from Emp a, Title b where a.id = b.emp_id

I run the query in SQL*PLUS, found out it was ROWID caused problem.

Can anybody tell me how to get rid of ROWID? or I missed something in datablock defination?

Thanks in adance.

Deborah
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 13 2002
Added on May 16 2002
2 comments
1,035 views