ONJava.com -- The Independent Source for Enterprise Java
oreilly.comSafari Books Online.Conferences.


AddThis Social Bookmark Button
  Self-Inflicted SQL
Subject:   sql
Date:   2006-03-10 04:10:10
From:   mmmmm1
plz reply the query that if we want to compare one column with in the same table with using update command.

(update categorydet e1,categorydet e2 set e1.cateid=1 where e1.cateid=e2.cateid)

is it correct or not .plz reply immidiately.

1 to 1 of 1
1 to 1 of 1