OraFAQ Forum: Reports & Discoverer » ORA-00913 too many values

Home » Developer & Programmer » Reports & Discoverer » ORA-00913 too many values

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-00913 too many values [message #184412]

Wed, 26 July 2006 08:26

kamran.it
Messages: 265
Registered: September 2005
Location: Karachi

Senior Member

select orderno from merch_order where merch_order.orderno not in 
(select orderno,ship,orderdate  from  export_order1 where export_order1.ship is not null)

Shows error
ORA-00913 too many values

Report message to a moderator

Re: ORA-00913 too many values [message #184497 is a reply to message #184412]

Wed, 26 July 2006 16:30

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

These columns are to be omitted from the subquery: ship, orderdate. After you do that, query should look like this:

SELECT orderno
  FROM merch_order
 WHERE merch_order.orderno NOT IN (SELECT orderno
                                     FROM export_order1
                                    WHERE export_order1.ship IS NOT NULL)

Report message to a moderator

Previous Topic:	Reports 6i Problem
Next Topic:	very urgent :how I order by my report within the report option not change in report query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 23:25:32 CST 2024