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!

Can anyone help resolve this query, an issue with ORA-00905: missing keyword

814f268f-bcc1-4762-8a7a-d7c114aa9d13Dec 2 2015 — edited Dec 3 2015

select t2.UserName, t4.recordId from (select TSLocation.lcName as UserName, t1.ckdCnt as OffCnt, t1.OffDocUri as OffDocUri from TSLOCATION right join

(select reNameUri, uri as OffDocUri, COUNT(renameuri) as ckdCnt from TSRECELEC where reNameUri <> 0 and ltrim(rtrim(reCheckedOutOn)) <> '' and ltrim(rtrim(reCheckOutPath)) <> '' and reCheckOutType <> 0 group by reNameUri, uri )

AS t1 on TSLOCATION.uri = t1.reNameUri ) as t2 left join TSRECORD as t4 on t4.uri = t2.OffDocUri group by t2.UserName, t4.recordId

The query fails on AS keyword on the last line of the very first column.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 31 2015
Added on Dec 2 2015
3 comments
375 views