On Dienstag, 9. Dezember 2008, Mogens Melander wrote: | I can't figure out why the "UNION" solution is missing 4 rows. I'll include | the 3 complete statements, so maybe someone smarter than me can figure out | why there's a difference in the result.
Without having "studied" your query, my guess would be: double rows. UNION eliminates those; if you need them, use "UNION ALL". Just a guess though... Ciao, Thomas -- Thomas Pundt <[EMAIL PROTECTED]> ---- http://rp-online.de/ ---- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]