>Must be Friday
>
>If I am selecting from multiple tables should my join have any conditions in it
>
>like
>
> join attribute
> on attribute.individual_ref = I.individual_ref
> and attribute.attr_code_ref=9289
>where condition
>
>
>or should I have
>
>
> join attribute
> on attribute.individual_ref = I.individual_ref
>where condition
> and attribute.attr_code_ref=9289
>
>
>thanks
When you have INNER join it doesn't matter.
But if you have right or left join the condition should be in the JOIN not in WHERE.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.