UPDATE one table based on JOIN of two tables. MySQL5
I want to update a field called "fab_code" in one table called "sharkey" based on a join of two tables called "sharkey" and "fee_programs." The below query runs but doesn't make any changes! Could someone help me with this?
UPDATE sharkey s, fee_programs f SET s.fab_code=f.fab_code WHERE s.fee_id=f.fee_id
This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.