Hi.
I have a problem with JOIN, INNER JOIN based on two tables as below
I was trying to JOIN them with no result actually (got mysql errors)and after few hours i give up
I belive there must be a solution but i think now that i don't understant JOIN - INNER JOIN but I don't know if You would like to help me in such problem.
this is display only table.

Table 1 - is created with:

    SELECT * FROM jawe_wpdatatable_8
    UNION ALL
    SELECT * FROM jawe_wpdatatable_9
    UNION ALL
    SELECT * FROM jawe_wpdatatable_9_1
    UNION ALL
    SELECT * FROM jawe_wpdatatable_9_2
    UNION ALL
    SELECT * FROM jawe_wpdatatable_9_3
    UNION ALL
    SELECT * FROM jawe_wpdatatable_9_4

and works fine - it is dynamicly created from other tables whose data is changing
It is created as sql query table, and look like this

Table 1

| uzytkownik  | other importand columns...  |
|-------------|-----------------------------|
| 2           | some data                   |
| 1           | some data                   |
| 2           | some data                   |
| 2           | some data                   |
| 2           | some data                   |

table 2 - jawe_users:

| ID  | user_nicename  | other not importand columns...|
|-----|----------------|------------------------------|
| 1   | bart           |                              |
| 2   | asia           |                              |

the result I expect should be like this:

table 1 
| uzytkownik | other importand columns... |
|------------|----------------------------|
| asia       | some data                  |
| bart       | some data                  |
| asia       | some data                  |
| asia       | some data                  |
| asia       | some data                  |

I want to replace 2,1 and other ID numbers with coresponding with them user_nicename from jawe_users

Tanks in advance for any help.

Best regards.