>1) SELECT abc.*,xyz.dfrom,xyz.dto FROM abc LEFT JOIN xyz ; > ON abc.fld1=xyz.fld1 WHERE dfrom>=20060101 AND dto<=20060131 > >2) SELECT abc.*,xyz.dfrom,xyz.dto FROM abc LEFT JOIN xyz ; > ON abc.fld1=xyz.fld1 AND dfrom>=20060101 AND dto<=20060131 >>Will (1) perform faster than (2)?