• thanks now if i have another table name empadd where i have to update at the same time and whose fields are

    EaddID address empid

    1 abc 1

    2 asd 2

    then what will be the change

    here empid of empadd is foreign key of the table emplyee