mysql - selecting from two tables in one query

[pozmu]

One question: how can I make this:
SELECT * FROM catone order by id desc limit 5

SELECT * FROM cattwo order by id desc limit 5

in single query?

[Defender1]

SELECT * FROM catone,cattwo order by id desc limit 5

theres a small chance that's wrong, cause that's how it's done in sql, dunno bout MySQL.
but try it. probably'll work

[firepages]

$yaks=mysql_query("SELECT * FROM catone,cattwo ORDER BY catone.id DESC");

while($row=mysql_fetch_assoc($yaks)){
while(list($key,$var)=each($row)){echo "$key , $var<br>";}}

should do the job.


DOH - Defender beat me to it !

[Defender1]

[pozmu]

hmmm, I was trying a query like this before (I use fetch_array), but this doesn't work - I get 10 (I added LIMIT 10) items but only from the first table.
One more time:
I have two tables. I want to get 5 newest items from each table in single mysql query. I know that is easy - I'm sure that I do query like this before, but... I don't remember how .