Sub Query Syntax

• paul welsh

  SSC Veteran

  Points: 204

  More actions

  April 26, 2005 at 6:25 am

  #164345

  HI,

  We have imported records into an sql dbase. It has appended two tables. It has been done in error and I need to delete the records that have been imported and leave the .

   

  My subquery looks like this:

  delete from tblorderline where OrderID in ( select * from tblOrders where Offercode = 'NWZ')

   

  But it errors saying that the select statement can have only one expression if there is no EXISTS intro.

  Have tried different things with no result - can anyone assist?

  Thanks,

   

  Newbie (Paul)

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  April 26, 2005 at 6:56 am

  #554849

  delete from tblorderline where OrderID in ( select OrderID from tblOrders where Offercode = 'NWZ')

• David Burrows

  SSC Guru

  Points: 65141

  More actions

  April 26, 2005 at 6:58 am

  #554851

  or

  delete ol

  from tblorderline ol

  inner join tblOrders o

  on o.OrderID = ol.OrderID

  and o.Offercode = 'NWZ'

  Far away is close at hand in the images of elsewhere.
  Anon.