Syntax error

• ramu.guggilla

  SSC Eights!

  Points: 829

  More actions

  June 20, 2008 at 6:47 am

  #192558

  Hi frnds

  when deleting the row i am getting the error: Syntax error near "a".

  i have a query :

  delete from table a where a.column = (select b.column from table b where a.column = b.column)

  thanks

  Rams

• MannySingh

  SSChampion

  Points: 12465

  More actions

  June 20, 2008 at 7:07 am

  #831726

  delete from a where a.column in (select b.column from b where a.column = b.column)

  Maninder
  www.dbanation.com

• steveb.

  SSC-Forever

  Points: 46733

  More actions

  June 20, 2008 at 7:07 am

  #831728

  it should be

  delete from a

  you don't need to state 'Table' a

• MannySingh

  SSChampion

  Points: 12465

  More actions

  June 20, 2008 at 8:39 am

  #831828

  Correct..

  I Just tried to match his Query..

  Maninder
  www.dbanation.com