Query Theory

[OnLiner]

Hi everyone,
I have a question...
I have an employees table, disciplines table, and attendance table. the employees is one-to-many with the discipline and attendance tables.

When I create a query with all three tables in it, not all of the employees are listed. I'm assuming it is because not all employees have matching records in the disciplines and/or attendance tables. Is this true?

I'd like to create an "Activity Report". That being all activity for all employees. I want the data to come from one master query if possible. The reason is I'm going to use this -->

http://www.tek-tips.com/faqs.cfm?pid=181&fid=5497

<-- to have the users choose which types of activities (query parameters) they want to view on the report. Also
I don't know enough about how querys work to be able to do this. Any help or advice would be greatly appreciated.

 

[AlexMidd]

Select the links between the employees table and the other tables, right click it and select "Join Properties". Select the option "Select ALL records from the employees table and only those records from the discipline/attendance table where the joined fields are equal."

Have fun! )

Alex Middleton

 

[lespaul]

and read Understanding SQL Joins to understand why.

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design

 

[OnLiner]

fantastic thanks!!!