Home » Developer & Programmer » Reports & Discoverer » ORA-00913 too many values
ORA-00913 too many values [message #184412] Wed, 26 July 2006 08:26 Go to next message
kamran.it
Messages: 265
Registered: September 2005
Location: Karachi
Senior Member
Hi


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
Re: ORA-00913 too many values [message #184497 is a reply to message #184412] Wed, 26 July 2006 16:30 Go to previous message
Littlefoot
Messages: 20901
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)
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:
  


Current Time: Fri Dec 09 11:39:33 CST 2016

Total time taken to generate the page: 0.05538 seconds