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 ofselect said that all recond selected from a and b.
thanks.