Re: a easy SQL question?

Thanks everyone who replied to my SQL question. Your inputs are greatly appreciated.

Have a good day and nice weekend.

Yong
yliu_at_creighton.edu

On Thu, 17 Feb 2000 yliu_at_creighton.edu wrote:

> Hi All,
>
> I have a table called dept. Two of the fields in dept table is emp_name
> and deptno. I want to select every emp_name from dept table except for two
> deptno (R% and X%). I am confused on which operator to use: OR or AND.
> My SQL statement is like:
> select emp_name, deptno
> from dept
> where ...
> and (deptno not like X% or deptno not like R%)
> and ...;
>
> However, I don't know if I should use AND in the above where clause?
> Maybe somebody has some suggestions that will clear my confusion.
>
> Thanks in advance for helping.
>
> Yong
> yliu_at_creighton.edu
>
>
Received on Fri Feb 18 2000 - 10:35:29 CST