Skip navigation links

MySQL Forums :: Performance :: LEFT JOIN with CASE WHEN


Advanced Search

Re: LEFT JOIN with CASE WHEN
Posted by: Stefan Rindeskar ()
Date: October 23, 2009 06:33PM

Hmm, yeah that join does not look nice, and definitely not from a performance perspective.

Can't you change the table structure or data so that they actually have some common denominator or something so that you can avoid the entire CASE...THEN...END?



Edited 1 time(s). Last edit at 10/23/2009 06:34PM by Stefan Rindeskar.

Options: Reply•Quote


Subject Views Written By Posted
LEFT JOIN with CASE WHEN 768 Chad Brogan 10/23/2009 02:25PM
Re: LEFT JOIN with CASE WHEN 284 Stefan Rindeskar 10/23/2009 06:33PM
Re: LEFT JOIN with CASE WHEN 254 Chad Brogan 10/23/2009 09:54PM
Re: LEFT JOIN with CASE WHEN 261 Rick James 10/23/2009 10:29PM
Re: LEFT JOIN with CASE WHEN 245 Chad Brogan 10/25/2009 01:34PM
PARTIAL RESOLUTION - Re: LEFT JOIN with CASE WHEN 230 Chad Brogan 10/27/2009 07:15PM
Re: PARTIAL RESOLUTION - Re: LEFT JOIN with CASE WHEN 84 Chad Brogan 11/14/2009 12:30PM
Re: PARTIAL RESOLUTION - Re: LEFT JOIN with CASE WHEN 77 Rick James 11/17/2009 11:44PM


Sorry, only registered users may post in this forum.
Click here to login
powered by phorum