Hi All

I got my backup table (Commlogin_Buckup) in mysql database with my live database (Commlogin)

Now as my live database is missing records in column batch, I want to insert the missing records were my Id key is equal to each other now I ran a script that I wrote but, I see that a lot of the records in Batch updated as ' ' Empty field??? When I Look at the original table the information is there?

UPDATE commlogin
INNER JOIN commlogin_Backup
ON commlogin_Backup.id = commlogin.id
SET commlogin.batch = commlogin_Backup.batch
What I'm I doing wrong?