|
|
|
|
|
|
Re: ORA-00913: too many values [message #599217 is a reply to message #599214] |
Wed, 23 October 2013 01:16   |
 |
msol25
Messages: 396 Registered: June 2011
|
Senior Member |
|
|
hi mist,
Your subquery will pass header id from subquery to outer query and it will give you matching header_id results.It will work like
equijoin.
Please use like this for getting better performance:
select a.*
from oe_order_lines_all a,
oe_order_headers_all b
where b.order_id = 4721
and a.header_id = b.header_id
[Updated on: Wed, 23 October 2013 01:16] Report message to a moderator
|
|
|
|
|
|