Help with select statement

[C Jamieson]

It's obvious I have only one ore in the water.
I am attempting to select (identify) records from a table where a specific field must equal certain values.
The problem I am having is that all the values must exist before any are to be selected.

For example

SELECT *
FROM `employees`
where Employee_ID = '1035'
and (Skill_Training_Type = 'SKILL1' or Skill_Training_Type = 'SKILL2')

Will select records with either of the values.

SELECT *
FROM `employees`
where Employee_ID = '1035'
and (Skill_Training_Type = 'SKILL1' and Skill_Training_Type = 'SKILL2')

Will select no records - obviously.

I want the select to select the records only if both records exist for the specific Employee_ID.

The statement is being used by a report generator so generating temporary tables and reselecting is not feasible.

Suggestions?

rykk