TABLE A
----------------
| ID | NAME    |
-----|----------
| 1  | Kristy  |
| 2  | Jesus   |
| 3  | Richard |
| 4  | Geoff   |
----------------

TABLE B
----------------------------
| TABLE_ID | ORDER | VALUE |
---------------------------|
| 1        | 1     | OH    |
| 1        | 2     | HAI   |
| 2        | 1     | THERE |
| 2        | 2     | PAL   |
| 2        | 3     | HOW   |
| 3        | 1     | YOU   |
| 3        | 2     | DOIN  |
| 4        | 1     | TODAY |
| 4        | 2     | MATEY |
| 4        | 3     | MATE? |
----------------------------

---------------------------------
! TABLE A.ID = TABLE B.TABLE_ID !
---------------------------------

FROM THESE TABLES I WOULD LIKE TO GET THE FOLLOWING RESULT SET:

-------------------------------|
| ID | NAME    | ORDER | VALUE |
-----|-------------------------|
| 1  | Kristy  | 2     | HAI   |
| 2  | Jesus   | 3     | HOW   |
| 3  | Richard | 2     | DOIN  |
| 4  | Geoff   | 3     | MATE? |
-------------------------------|