UPDATE TmpTable INNER JOIN Users ON TmpTable.GUID = Users.GUID SET Users.Size = [TmpTable].[Size]
This works fine where [TmpTable].[Size] = TEST123 and [Users].[Size] = TEST321
It updates [Users].[Size] to TEST123 when GUID matches
However, it doesn't work if there's a NULL value in EITHER table entry.
This is really annoying. Does anyone know why this is?
Prior I was running an update table for ALL entrys where GUID Matches, but this took too long and locked the Users (odbc linked) table.