i need help please

[Ra7al143]

hi everybody,

i need help please with the following example:

i have the following table:

id -------------- coursenumber
123 -------------- 222
123 -------------- 111
1234 -------------- 222
232 -------------- 111
1234 -------------- 111

i made a query that select every id that doesn't have the course number 222 and it gave me the following ids

123
1234
232

how can i get rid of id number 123 and id number 1234 since both have course number 222 already?

[JKing]

hi everybody,

i need help please with the following example:

i have the following table:

id coursenumber
123 222
123 111
1234 222
232 111
1234 111

i made a query that select every id that doesn't have the course number 222 and it gave me the following ids

123
232

how can i get rid of id number 123 since it has course number 222 in the first row already?

If you have duplicate ids you will get strange results. 123 is listed twice... once with a course number of 222 and once with a course number of 111. So the query is functioning properly by only returning 123 once.

[Ra7al143]

thank you for your reply.

if you look at my example i want the query to return only id number 232 since it is the only id that didn't take course number 222.

[JKing]

Sorry I misread that.

Give this a try:

SELECT id, courseNumber
FROM tblTable
WHERE id Not In (Select ID from tblTable WHERE courseNumber = 222);
 

[Ra7al143]

thank you so much it did work with me.

[JKing]

You're welcome.

Jking