List All

[Ammodog]

How can I , I have an Employee Table and lets say an Emergency Time Used Table. I am trying to create a query that list's all employee's with there Emergency time used. I have the relationship between the two. But the query only brings up employees that are in both the Employee and the Emergency time used table. How can I list those who have not used any emergency time in the query as well. Thanks for the help Christopher Abney
"There is no limit to the good you can do if you dont care who gets the credit"
[Afro2]

 

[muneco]

Try using a LEFT JOIN something like this:

SELECT *
FROM employee LEFT JOIN emer_time_used ON [employee].[emp_id] = [emer_time_used].[emp_id];

 

[lespaul]

Or change the join properties in the relationship window. Leslie
landrews@metrocourt.state.nm.us

There are 10 types of people in the world -
those who understand binary
and
those who don't!