Hi,
(SELECT * FROM a limit 10) union (SELECT * FROM b limit 10)
is what you need
Bèrto
2011/11/23 Капралов Александр <alnkapa(at)gmail(dot)com>
> Query is:
> SELECT * FROM a UNION SELECT * FROM b ORDER BY time DESC LIMIT 100
>
> how can i get only last 100 row from a and b and then do union. Explain of
> select said that all recond selected from a and b.
>
> thanks.
>
--
==============================
If Pac-Man had affected us as kids, we'd all be running around in a
darkened room munching pills and listening to repetitive music.