UPDATE statement allows you to update column from another table. You can use the UPDATE statement to update columns value of a single row, a group of rows, or all rows in a table.
To update column from another table, use the following syntax:
tablename: The table name from which you want to update.
field1: Column name to be updated.
In the above example, we have updated "tblCustomer" table by fetching the data from "tblCustomerLoan" table.