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
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
Re: ORA-00913 too many values [message #184497 is a reply to message #184412] Wed, 26 July 2006 16:30 Go to previous message
Messages: 21127
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 Jul 23 08:05:22 CDT 2017

Total time taken to generate the page: 0.08167 seconds