It seems that the functional difference between specifying a predicate in 'join..on' and specifying it in 'where' is that, if the predicate only involves a field from one table (eg tax_year <= 2005), then with 'join...on' it's applied to the table before the join is made, and with 'where' it's applied to the rows that result from the join.
So I suppose the most efficient place for this kind of predicate is in 'join...on'.
Anti-nuisance lawsuit warning: The purpose of these notes is to remind me, Zoegond, of stuff or to help me work stuff out. They may contain mistakes.
Quick
- ($a, $b....) = unpack("A2A7...", $packed)
- push( array, list )
