I have 2 tables containing employee information. The names are in different
formats - 1st table has name in lname, fname and MI format whilest the other
has either fname, lname or lname, fname or just lname. There is no employee
number as a unique identifier. How am I going to merge these 2 tables

Thanks
akhilash