found rows in union

[Lorderon]

How can I find the number of rows a query returns when I'm using UNION ?

for example, how can I know how much rows the next query returns:
(SELECT price FROM table1 WHERE id>100)
    UNION
    (SELECT price FROM table2 WHERE id>150)


thanks in advance,
-Lorderon.



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]