Skip to Main Content

SQL & PL/SQL

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!

Using select * in a join statement

638473May 10 2008 — edited May 11 2008
Ok Wizards,
If I use this code: (select * from tablea a, tableb b where a.index = b.index) joined, I can reference any column in either table using joined.column except a column named in both tables. If both tables contained a columnxyz, any reference to joined.columnxyz returns an error. Must be a naming convention this newbie is unaware of (among many other things). Your wisdom and patience are greatly admired.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 8 2008
Added on May 10 2008
4 comments
685 views