Hai friends!
           I have a query
  "UPDATE category set c.pro1 = 'this is a good program' from catpro cp, category c where cp.id = c.id and c.id = 1" .When i try to execute this query , it says there is a syntax error in query expression" pointing to 'from' keyword of the query. Dont know wats the error .
Could anyone help me regarding this . Its very urgent .


with regards
prasath.g

change the query to:

UPDATE c set c.pro1 = 'this is a good program' from catpro cp, category c where cp.id = c.id and c.id = 1