Query Question

[Demon36]

I need to create a query that list employees that have had training but I can only list them once,not once for each course attended. Also I am not allowed to create a new table for this. Can anyone help me?

 

[tlbroadbent]

It would help to know the structure of table(s) involved and the kind of information that is available.

Assume you have Employees, Training and EmployeeTraining tables with the following structures.

Employees (EmpID, EmpName, ...)

Training (CourseID, CourseName, ...)

EmployeeTraining (EmpID, CourseID, DateOfTraining, ...)

You can create a query like this.

Select EmpID, EmpName
From Employees
Where EmpID In (Select EmpID From EmployeeTraining)

If you find this doesn't fit your database structure, please post the structure so we can help. Terry

http://members.home.net/tlbroadbent/prog.htm

_____________________________________
Man's mind stretched to a new idea never goes back to its original dimensions. - Oliver Wendell Holmes