Palesa Mafanya

Palesa Mafanya

  • 2k
  • 12
  • 458

Update table with values from another table

Apr 22 2020 1:58 PM
This is the query I ran but it gave me error message:
 
UPDATE B_EMPLOYEES b
SET SUBURB=(SELECT SUBURB FROM B_PERSAL_DUMP a
                          WHERE  a.IDNUM=b.id_number)

Answers (12)