This is probably a simple question, but I seem to be butting my head against a brick wall. Here's the scenario: T have two databases, call them A and B. A is created when a user registers on a forum site here at the Uni, and B is their "profile". There is a common ID in both files. Because of a bug in the way Invision works (the forum software), there is one field in A that is out of sync with B. A.member_type is a numeric based on their "membership type" (student, teacher, etc) - single digit. B.member_group is the membership type in text, based on what they put in A - for example, if A.member_type = 3, then B.member_group would be "Student". But both tables are editable by the user, so they don't match up (that is being fixed over Christmas !). What I need to do is retrieve all records in both tables, joined by their ID, and change B.member_group based on the contents of A.member_type. But every time I try it, I get various and sundry errors, and one of our developers has told me that it cannot be done programmatically. As it is not I who will be running this script, but someone with zero SQL knowledge, is there an easy way of doing it ?

Software/Hardware used: