[eluser]Nikhil Vijayan[/eluser]
The query doesn't make sense where does tbl and tb come from there is only tbl1 and tbl2
or is it typo mistake .. whetever correct one is
Quote:update tbl1,tbl2 set tbl1.field =’aaa’,tbl2.field=’bbb’ where tbl1.field =’ccc’ AND tbl2.field =’ccc’
if it doesn't work try this
Quote:update tbl1,tbl2 set tbl1.field =’aaa’,tbl2.field=’bbb’ where tbl1.field = tbl2.field AND tbl1.field =’ccc’