MAIL PROTECTED]
Subject: Re: found rows in union
"Lorderon" <[EMAIL PROTECTED]> wrote:
> I'm running MySQL 4.0 and it doesn't support sub-queries...
>
> I've checked and found that the next query returns rows of counting
each
> union part seperatedly and c
"Lorderon" <[EMAIL PROTECTED]> wrote:
> I'm running MySQL 4.0 and it doesn't support sub-queries...
>
> I've checked and found that the next query returns rows of counting each
> union part seperatedly and could make sum on its rows:
> (SELECT COUNT(*) FROM table WHERE id>100) UNION ALL (SELECT
I'm running MySQL 4.0 and it doesn't support sub-queries...
I've checked and found that the next query returns rows of counting each
union part seperatedly and could make sum on its rows:
(SELECT COUNT(*) FROM table WHERE id>100) UNION ALL (SELECT COUNT(*) FROM
table2 WHERE id>150)
returns:
+---
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
