I think I just got it working using Views. Very cool!
CREATE OR REPLACE VIEW NewAlloysPlusRatings AS
SELECT brand_name, date_added, description, new_alloys_added_by_users.Alloy_ID_No, fz_score, id_of_user_who_added_this, id_of_user_who_provided_this_rating, let_other_people_use_this_info...