First, I would recommend you join the tables in the connection if possible. This is always preferred over data blending.
If you can ONLY do blending, then note that you cannot blend to a 3rd level. Tableau only allows one level of data blending. As an example, you can go from Connection A to Connection B, but you cannot go from A to B to C. You can go from A to B and A to C though.