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

advertisement

AddThis Social Bookmark Button
Article:
  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.
thanks


1 to 1 of 1
  1. Find Child
    2007-12-17 10:41:37  nv_thien [View]

1 to 1 of 1