mysql problem with UNION

[RP]

Hello All,

I have a strange problem with a UNION of 3 queries. The 3 separate
select-queries return (at this point) respectively 4, 3 an zero rows,
but the UNION returns no rows at all.
When I take the query that returns 0 rows, and put it in front of the
other two, everything to go fine (I get 7 rows), but this is of course
no real solution, next time another query returns zero rows.

Anyone a solution or workaround? (I use mysql 4.1.1, tries both InnoDB
and myIsam).

TIA
RP

[Bill Karwin]

RP wrote:

I have a strange problem with a UNION of 3 queries. The 3 separate
select-queries return (at this point) respectively 4, 3 an zero rows,
but the UNION returns no rows at all.

Did you try UNION ALL?

Bill K.

[RP]

Bill Karwin stuurde mij op 15-10-2004 23:21 het volgende bericht:

RP wrote:

I have a strange problem with a UNION of 3 queries. The 3 separate
select-queries return (at this point) respectively 4, 3 an zero rows,
but the UNION returns no rows at all.

Did you try UNION ALL?

Bill K.

Thanks,

No I have not, and will try next monday.

RP