Help.. Please ??!?!?!

[shariefoo]

Ok people.. I really need your help in this.

I have to create a query (or 3 queries) that would do the following

1st one is to select from xxx ID to xxx ID and thats easy with the between command.

2nd one is to select and search for only 1 ID which is again easy with the help of critiria..

3ed one requires me to seach for selected IDs. I have now officially spent 2 hours on it without getting a clue.

Please help.

 

[namliam]

Try looking into the IN operator

Select *
From tblEmployee
where ID in (1,5,10,15)

Will return employee numbers 1,5,10 and 15

Regards

The Mailman