Since I don't use MySQL 4.1, is this query OK?
SELECT SQL_CALC_FOUND_ROWS * FROM
((SELECT * FROM t1 WHERE id>100 GROUP BY country)
UNION ALL
(SELECT * FROM t2 WHERE id>150 GROUP BY country)
LIMIT 0,10);
I want this to return all the rows of the UNION sub-query there.. the reason
I used it as sub-query is that I want to count the rows, and then use:
SELECT FOUND_ROWS();
to get the number of rows supposed to be retuned without using the LIMIT..
Is all above correct?
thanks,
-Lorderon.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
