Need all employees in query

[KimMazz]

I have a sql query to an access database. It returns employee information
from the employees table and connects each employee to the programs they run
from the programs table. The problem I am having is that if the employee
does NOT head any programs their information is not being returned in the
query.

The ProgramContact is the Emp_ID from the employee table. So if the Emp_ID
is not in the Programs table then the employee doesn't get listed in the
output.

My question, what do I have to change to get the query to return all
employees regardless of whether they head a program or not?

help Please,

Kim

<cfquery name="rsGetEmployeeList" datasource="#request.dsn#">
SELECT yda_Employees.Emp_ID, yda_Employees.Emp_Role,
(yda_Employees.Emp_FirstName) + ' ' + (yda_Employees.Emp_LastName) AS
EmployeeContact, yda_ProgramsServices.Program_ID,
yda_ProgramsServices.ProgramTitle, yda_ProgramsServices.District
FROM yda_Employees INNER JOIN yda_ProgramsServices ON yda_Employees.Emp_ID =
yda_ProgramsServices.ProgramContact
GROUP BY yda_Employees.Emp_ID, yda_Employees.Emp_Role,
yda_Employees.Emp_FirstName, yda_Employees.Emp_LastName,
yda_ProgramsServices.Program_ID, yda_ProgramsServices.ProgramTitle,
yda_ProgramsServices.District
ORDER BY yda_Employees.Emp_ID ASC, yda_ProgramsServices.District DESC
</cfquery>

[JMGibson3]

Change INNER JOIN to LEFT JOIN, be aware that everything from the second table will be NULL if you're tempted to add WHERE clauses (and it's a slick way to zero in on those who are missing).

[KimMazz]

Thank You!! I knew I had to change the join, but I didn't know what to
change it to.

Kim

"JMGibson3" <webforumsuser@macromedia.com> wrote in message
news:dvmovg$hpt$1@forums.macromedia.com...

> Change INNER JOIN to LEFT JOIN, be aware that everything from the second
> table will be NULL if you're tempted to add WHERE clauses (and it's a
> slick way to zero in on those who are missing).