The left join will bring back columns from both tables if you use the *. This will result in too many columns being returned to the insert statement. Try using the column names instead of *. (It's also a good practice in general to avoid using the * in SQL statements.)