| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Thomas Pundt | Date: | December 9 2008 1:53pm |
| Subject: | Re: Uptimize: join table on if() | ||
| View as plain text | |||
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 <thomas.pundt@stripped> ---- http://rp-online.de/ ----
| Thread | ||
|---|---|---|
| • Uptimize: join table on if() | Mogens Melander | 8 Dec |
| • Re: Uptimize: join table on if() | Peter Brawley | 8 Dec |
| • Re: Uptimize: join table on if() | Brent Baisley | 8 Dec |
| • Re: Uptimize: join table on if() | Mogens Melander | 9 Dec |
| • Re: Uptimize: join table on if() | Thomas Pundt | 9 Dec |
| • Re: Uptimize: join table on if() | Mogens Melander | 9 Dec |