WHERE clause question ....

From: Sebastian K F Hung <skfhung_at_undergrad.math.uwaterloo.ca>
Date: Wed, 1 Dec 1993 06:48:07 GMT
Message-ID: <CHCG88.Ayz_at_undergrad.math.uwaterloo.ca>


Is there any rule govern the join condition in the WHERE clause in an SQL ?
i.e. the join ( or condition ) has to be from top to bottom or from left to right , etc. ?

i.e. if I alter the sequence of coding the condition in a WHERE clause would that affect the performance of the query or application ?

thx ....


Have a nice day !
Received on Wed Dec 01 1993 - 07:48:07 CET

Original text of this message