How can use NOT IN query
Database
2
Posts
2
Posters
0
Views
1
Watching
-
I have list of users in the database, in the form once the users are selected, selected users should not display again while again selecting users. so I want to use NOT IN query. How can i use it.
swguy23 wrote:
so I want to use NOT IN query. How can i use it.
SELECT *
FROM MyTable
WHERE id NOT IN(1, 3, 5, 7, 13, 17)
Upcoming Scottish Developers events: * We are starting a series of events in Glasgow in 2007. Are you interested in a particular subject, or as a speaker? * Developer Day Scotland: are you interested in speaking or attending? My: Website | Blog | Photos