How to trace a column back to its original column

[JiaTao Tao]

SQL like this:
```
SELECT T1.NID,
       T1.NAME,
       T2.COMPANY
FROM
  (SELECT (U.ID +100) AS NID,
          U.NAME AS NAME
   FROM USERS U) T1
JOIN
  (SELECT (J.ID +100) AS NID,
          J.COMPANY
   FROM JOBS J) T2 ON T1.NID = T2.NID
```
What I wanted is that T1.NID comes from USER.ID, T1.NAME comes from
USER.NAME.

Has anyone done similar work? Is there a ready-made example to refer to?


Regards!

Aron Tao