The And Operator

[Lftsk]

I feel quite silly about this, but it just doesn't seem to work.

I have a table that contains 2 columns.
Duplicates exist for both. But I'll just use Column_1 for the example. Please see the example below.

Column_1 Column_2

CB 12345
CB 67890
BA 12345
BA 67890

In my select statement, all I want to do is disclude the row that has Column_1 = 'CB' AND(!) Column_2 = '12345'

My Select statement is

SELECT *
FROM table1
WHERE (Column_1 <> 'CB' AND Column_2 <> '12345')

But it is also discluding ALL 'CB's. It seems to be evaluating the AND as an OR.

Any help would be greatly appreciated.

 

[tlbroadbent]

If I understand your question correctly, either of the following will produce the answer you seek.

Select * From table1
Where col1<>'cb' or col2<>12345

Select * From table1
Where Not (col1='cb' And col2=12345)
Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains &quot;Suggestions for Getting Quick and Appropriate Answers&quot; to your questions.