MYSQL Tables Conflict Need Help Joining tables : MYSQL PROBLEM! HELP PLEASE..
<h3>I HAVE TWO TABLES CALLED kingdom & player</h3>
<pre>
kingdom table:
+----------------------------------------
| ID | kingdom              | timestamp |
+----------------------------------------
| 1  | Kingdom 47           | time      |
| 2  | Kingdom 48           | time      |
----------------------------------------+

player table:
+---------------------------------------+
| ID | name                 | kingdom   |
+---------------------------------------+
| 7  | some name            | 1         |
| 8  | some name            | 1         |
| 9  | some name            | 1         |
+---------------------------------------+

<h2><h2> Help Needed MYSQL</h2>
<h3><strong>I would like to join them and get out some thing like the one below:</strong></h3>
<b><mark>I WANT THE OUTPUT LIKE THIS:
+-----------------------------------------+
| ID | name                 | kingdom     |
+-----------------------------------------+
| 7  | some name            | Kingdom 47  |
| 8  | some name            | Kingdom 47  |
| 9  | some name            | Kingdom 47  |
+-----------------------------------------+</mark></b>
</pre>