Amit wrote:
> Hi Sql Gurus,
>
> Written below are two queries returning the same result
> set.
>
> SELECT A.Col1 FROM TableA AS A INNER JOIN TableB AS B ON
> (A.Col1 = B.Col1) AND (B.Col2 = 5)
>
> SELECT A.Col1 FROM TableA AS A INNER JOIN TableB AS B ON
> (A.Col1 = B.Col1) WHERE (B.Col2 = 5)
>
> Above two queries seem to be very simple, but in case of
> complex queries joining three or more tables, i think its
> better to restrict the number of records satisfying the
> join condition by using AND clause immediately after the
> join condition than to put a filter using WHERE clause at
> the end.
>
> To my understanding WHERE acts as a filter for the final
> recordset available, and AND can be used to filter out the
> unnecessary records before the WHERE clause comes in
> picture.
>
> I want to know which one of the two approaches is better
> to use. Feel free to let me know if my question isn't
> clear.
>
> Thanks in advance,
> Amit

> To my understanding WHERE acts as a filter for the final
> recordset available, and AND can be used to filter out the
> unnecessary records before the WHERE clause comes in
> picture.

> I want to know which one of the two approaches is better
> to use.

"Amit" <contactamit22@indiatimes.com> wrote in message
news:062801c4ab64$d9442e60$a401280a@phx.gbl...
> Hi Sql Gurus,
>
> Written below are two queries returning the same result
> set.
>
> SELECT A.Col1 FROM TableA AS A INNER JOIN TableB AS B ON
> (A.Col1 = B.Col1) AND (B.Col2 = 5)
>
> SELECT A.Col1 FROM TableA AS A INNER JOIN TableB AS B ON
> (A.Col1 = B.Col1) WHERE (B.Col2 = 5)
>
> Above two queries seem to be very simple, but in case of
> complex queries joining three or more tables, i think its
> better to restrict the number of records satisfying the
> join condition by using AND clause immediately after the
> join condition than to put a filter using WHERE clause at
> the end.
>
> To my understanding WHERE acts as a filter for the final
> recordset available, and AND can be used to filter out the
> unnecessary records before the WHERE clause comes in
> picture.
>
> I want to know which one of the two approaches is better
> to use. Feel free to let me know if my question isn't
> clear.
>
> Thanks in advance,
> Amit