Re: and / where

BigLearner wrote:
> Hai everyone,
>
> Can someone tell me whats the difference using AND and WHERE in the
> ansi join.
>
> Its basically used to further filter the query, atleast thats what i
> suppose.
>
> Can someone comment ?
>
> I see they are used almost in similar situations everywhere. I don't
> follow this.
>
> BigLearner

WHERE and AND are essentially the same thing.

The first condition is identified with WHERE ... subsequent conditions may be identified with AND <additional condition>. and there is also OR.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org