Posted by Greg D. Moore \(Strider\) on 05/25/05 03:29

"ZeldorBlat" <zeldorblat@gmail.com> wrote in message
news:1116962785.380752.74920@g49g2000cwa.googlegroups.com...
> Why use a sub-query at all?
>
> select SSN
> from tblPerson
> where MiddleInitial = 'X'
> or MiddleInitial = 'Y'
>
> select SSN
> from tblPerson
> where MiddleInitial = 'X'
> and MiddleInitial = 'Y'

This one won't work, since a MiddleInitial can't be both X AND Y.

>
> select SSN
> from tblPerson
> where MiddleInitial = 'X'
> and MiddleInitial != 'Y'
>

[Back to original message]