[adubb]

any sql guru's know whats wrong with this??


select part.partno, partdesc, unitprice, orders.orderno, orderdate
from s1.part, s1.orders, s1.orderprod
where part.partno = orderprod.partno(+)
and orders.orderno(+) = orderprod.orderno
and upper(partdesc) like 'A%'
or upper(partdesc) like 'C%'
or upper(partdesc) like 'S%';

[dennispopel]

Hello,

What are these (+) in the statement?

[bannme]

Originally Posted by adubb

any sql guru's know whats wrong with this??


select part.partno, partdesc, unitprice, orders.orderno, orderdate
from s1.part, s1.orders, s1.orderprod
where part.partno = orderprod.partno(+)
and orders.orderno(+) = orderprod.orderno
and upper(partdesc) like 'A%'
or upper(partdesc) like 'C%'
or upper(partdesc) like 'S%';

Which database do you use? How they config?
Why do you want to put s1.xxx? In here do you mean s1 is database? If so it doesn't need. And again what is (+)?