I'm trying to join two tables by sales rep name. However, one table has the name in this order last name, first name. The other table is first name, last name. Has anyone attempted to join a table this way? I've tried google, but I'm mostly getting information on converting order formats for names. As always, any and all help is greatly appreciated. Thank you!