Pulling info from two tables

[Aftershock00]

I'm kinda new at this, so bear with me.

I have two tables set up (kingdoms, kingdoms2) with identicle columns, but none of the info in them is the same (in other words, bothe tables have kingdom, alliance, age, networth, land, honor, but all the entries are different).

I have this:

$query="SELECT * FROM kingdoms, kingdoms2";

Now, when I have "SELECT * FROM kingdoms" the page comes up correctly. But when I add ", kingdoms2" the page loads 3,000 results, even though there's less than 200 entries in the tables. How can I combine the info from the two tables onto one page?

Also, how would I add ORDER BY? When I add that in after kingdoms2 the page won't display any results.

Thanks 🙂

[LordShryku]

http://dev.mysql.com/doc/mysql/en/UNION.html

[rachel2004]

This is a commonly asked question. What you're experiencing is the Cartesian product. Here is what you should try:

SELECT t.column1, t.column2, u.column1, u.column2
FROM kingdoms AS t,
kingdoms2 AS u
WHERE t.id = u.id
AND t.id = '20'
ORDER BY t.id;

Do a search using this forum's search engine as I've said, this is a frequently asked question and you're bound to find many examples of how to do this.