how to update two table values in a single sql query
i have a two table as 'Tabl1' and 'Table2' and two table field are ID,Username is common for both table
Now i need a single update query to update both table
I try to write a code as two update query
update table1 set Username='abc' where Id=1
update table2 set Username='abc' where Id=1
but i need s single query to update a both table.