noyearzero - 6:05 pm on Jun 21, 2012 (gmt 0)

rocknbil:

Is there any speed advantage to 'move the "joining" to the where clause' as opposed to what i suggested? I always thought it was faster to filter out as many rows from the join table in the ON clause rather than in the FROM table's WHERE? But to be honest i could be completely wrong.