Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Selecting problem...

Author  Topic  Sparky Starting Member 2 Posts Posted - 2001-04-23 : 15:15:42 Hello SQL guru's, I'm having trouble selecting records. I'll first explain how the table is build. id, name, interest ------------------ 1, sparky, 1 2, jimmy, 2 3, jimmy, 1 4, michael, 2 Now I want to select the people that have interest 1 AND 2. In this case I would only get 'jimmy'. The 'AND' part is my problem. It's probably very easy, but I am really stuck here. Thanks in advance!