At 05:04 PM 11/15/2004, Chad Z. Hower aka Kudzu wrote:

>from
> "CustomerHasLead" CHL
> join "Lead" L on L."LeadID" = CHL."LeadID"
>
>Given this join does it matter performance or other wise which way the = is?

No, not for inner joins. Outer joins are dependent
on the order of tables - as they must be - but not
on the order of terms in the equality.

Regards,


Ann