Re: Optimize the query, help me please.

[Bèrto ëd Sèra <berto.d.sera@xxxxxxxxx>]

Hi,

(SELECT * FROM a limit 10) union (SELECT * FROM b limit 10)

is what you need

Bèrto

2011/11/23 Капралов Александр <alnkapa@xxxxxxxxx>

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.