>Hi all,
>
>Can someone advise me the performance of SQL Select 1) vs 2):
>
>

>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)?
>

While table do dFrom and dTo come from? If it's XYZ, then the two queries don't give the same results, so optimization is irrelevant.

Tamar