need to know who if there are no records

  • Thread starter Thread starter martin
  • Start date Start date
M

martin

have a table of people and a table of only when they come
(the date) need to know if for a certain period someone
didn't come...
Any help would be greatly appreciated.

Thanks
Martin
 
martin said:
have a table of people and a table of only when they come
(the date) need to know if for a certain period someone
didn't come...
Any help would be greatly appreciated.
Click to expand...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Use a LEFT JOIN to join the two tables. E.g.:

SELECT L.LastName, R.VisitDate
FROM People As L LEFT JOIN Visits As R
ON L.PersonID = R.PersonID


If you want ONLY those who did not visit use the criteria:

WHERE R.PersonID Is Null

- --
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQF9K4YechKqOuFEgEQJmbwCdFT5LCDsDvkeMitdcsmQm6RkauUMAoJz/
5rZMPh3AiKM7oiN6EmzaNNxg
=s7Dh
-----END PGP SIGNATURE-----
 
Back
Top