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.