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: 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)
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: Sun Dec 08 07:43:18 CST 2024