Mergin a single column in table X with multiple columns table Y - Need help with M/SQL code

Hi all,    I have two tables, X and Y.   Table X contains four different levels of code. 1 digit codes, 2 digit codes, 3 digit codes and 4 digit codes. (levels of company hierarchy) looks like th...