RE: found rows in union

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

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 could make sum on its rows: > (SELECT COUNT(*) FROM table WHERE id>100) UNION ALL (SELECT

Re: found rows in union

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: +---