Simple Query Question

[Chrism]

I have 2 tables. One is a list on (say) 100 files of w/ID's, Ee names,
etc, for every time an audit was performed on an Ee's work. The 2nd
table is joined by the ID# for only when an error was found in that
audit-so is only about 10% the size=every file in table 2 has an ID on
table 1, but not the otherway around.

How do I run (design) a query where ALL of list one (w/in a date
range-which I can do) is showing and the individual results show only
if there are some, otherwise those fields would be blank?

Thank You

 

[Guest]

SELECT 1stTable.ID, 2ndTable.Errors, 1stTable.Names
FROM ID LEFT JOIN 1stTable ON 2ndTable.ID = 1stTable.ID;