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!

ORA-00904: "S"."DATAID": invalid identifier

483346Jun 29 2006 — edited Jun 11 2008
I have been working on query that I keep getting this error on. I'm not sure why, because it is a valid field name in the view. When I run the inner joins on their own, they run with no problems. I'm just about out of resources. Can someone please help? Here is a copy of the script I have been working on. The boldface characters are where the errror is occurring.

SELECT
DISTINCT k.dataid AS folder_id,
k.name AS folder_name,
k.path AS folder_path,
s.name AS file_name,
s.dataid AS file_id,
m.event AS action,
trunc(m.auditdate) AS action_date
FROM
VDTreeFiles s
INNER JOIN
TDAudit a
ON a.dataid = s.dataid
INNER JOIN
VDAuditFileActivity m
ON a.dataid = m.dataid
INNER JOIN
VDTreeFolders k
ON a.dataid = k.dataid;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 9 2008
Added on Jun 29 2006
11 comments
2,832 views