I want to be able to JOIN a single table to many other tables while still being
able to manipulate the JOINED fields and their values.

The INNER JOIN only joins tables in a hierarchy style:
A-
 B-
 C-
  D

I want to be able to join ONE table to MANY tables:

        D
        |
          B-A-C
        |
        E