Can I use a RIGHT JOIN with an AND EXISTS in a query? 1

[DPlank]

I have a RIGHT JOIN that returns me the correct number of rows. Can I use this within an existing query? The query (and syntax error returned) below

select ba.ACCOUNTNUMBER, pp.CATALOGUEPRODUCTID
from ccsowner.bsbbillingaccount ba, 
       ccsowner.bsbportfolioproduct pp
Where rownum < 1000
And exists (select ba_pri.ACCOUNTNUMBER
                  from ccsowner.bsbbillingaccount ba_pri right join ccsowner.bsbportfolioproduct pp_pri on ba_pri.PORTFOLIOID = pp_pri.PORTFOLIOID order by ba_pri.ACCOUNTNUMBER)
and   ba.PORTFOLIOID = pp.PORTFOLIOID
and pp.STATUS = 'EN'

Syntax error: missing right parenthesis

Cheers,
Dave

"Yes, I'll stop finding bugs in the software - as soon as you stop writing bugs into the software." <-- Me

For all your testing needs: Forum1393

 

[jaxtell]

Remove the order by in the inner select and try it.

-----------------------------------------
I cannot be bought. Find leasing information at

http://www.joshaxtell.com/

 

[DPlank]

Thanks - I'll try that!

Cheers,
Dave

"Yes, I'll stop finding bugs in the software - as soon as you stop writing bugs into the software." <-- Me

For all your testing needs: Forum1393