SELECT dbo.employees.ID, dbo.courses.id AS tc.id, dbo.employees.last_name, dbo.employees.first_name, dbo.employees.dept, dbo.employees.status,
dbo.courses.course_name, dbo.usertraining.empID, dbo.usertraining.courseID,dbo.usertraining.completed
FROM dbo.employees INNER JOIN
dbo.usertraining ON dbo.employees.ID = dbo.usertraining.empID INNER JOIN
dbo.courses ON dbo.usertraining.CourseID = dbo.courses.id
WHERE (dbo.employees.status = 'active') AND (dbo.usertraining.completed = 'yes')
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.