How to join two collections?

[Guest_imported]

Consider the following table:

Name Skill
---- -----
John ASP
John VB
John C++
George ASP
George Java
George C#
Tom C#
Tom C++

I want to find the people who has both the skills of ASP, and C#.

Apparently "Union" isnot the right command to use:
(Select Name from table where Skill="ASP&quot UNION
(Select Name from table where Skill="C#&quot

But what SQL command to use?

Thanks a lot.

 

[gdervage]

One way to do it is to use or.
This is what the SQL would look like.

SELECT tblData.LastName, tblData.FirstName, tblData.MiddleName
FROM tblData WHERE (((tblData.LastName)="Smith&quot) OR (((tblData.LastName)="Jones&quot);

This is really easy with the query builder in access 97 or higher.

Let me know if this helps or if you need to ask more questions.

Guy Dervage