>>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.

Thank Boris

can you point me at an explanation of that rule. I think aomi did a while ago but I can't finr the message.

No worries if you can't :-)