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 Melander8 Dec
  • Re: Uptimize: join table on if()Peter Brawley8 Dec
  • Re: Uptimize: join table on if()Brent Baisley8 Dec
    • Re: Uptimize: join table on if()Mogens Melander9 Dec
      • Re: Uptimize: join table on if()Thomas Pundt9 Dec
        • Re: Uptimize: join table on if()Mogens Melander9 Dec