So today update data cross table in a MYSQL database. It took me way longer than it should have.  I spent way too much time trying to get my join to work only to continue getting syntax errors.  So long story short. If you are doing a cross table update in MYSQL you cannot use a join. Rather you must use WHERE a simple example looks like:

UPDATE TableToUpdate, TableToPullInfoFrom


TableToUpdate.col1 = TableToPullInfoFrom.col1,

TableToUpdate.col2 = TableToPullInfoFrom.col2,

TableToUpdate.col3 = TableToPullInfoFrom.col3,

TableToUpdate.col4 = TableToPullInfoFrom.col4


And I will just leave this here so I don’t make that mistake again.