select particular records only

[johnbest]

Hi there,

I am new to sql and below is my table structure-

cid name
1 A
2 A
2 B
3 A
3 B
3 C
4 A
5 A
5 C
6 A

I want only those records where name is A or C and not B

I mean the output will be -

cid name
1 A
4 A
5 A
5 C
6 A

thanks in adv
John

[June7]

Try:

SELECT * FROM tablename WHERE cid Not In (SELECT cid FROM tablename WHERE [name] = "B");

Review this thread with similar requirement https://www.accessforums.net/queries...ues-39846.html