Join Query Woes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two tables (tMain and tNames). The tNames table holds (you guessed it) Names (fName (primary) and flocation). The tMain holds reporting records (fRecordID, fName, fSales, etc). What I want to see is a count of records based on the Names. I can do this where tMain.fName = tNames.fName but it doesn't show the tnames.fNames that don't have any records in tMain (I.e. the count would be 0). How would I get the query to show me those as well so I can track who is NOT using the system?
 
I think you want to do a left join of tNames to tMain.
That will give you all from tNames and only those from
tMain that match tNames.

In query design view, link your tables. Then, position
your cursor on the link line, click the right mouse
button, and you will be able to select the join that you
want.
-----Original Message-----
I have two tables (tMain and tNames). The tNames table
Click to expand...
holds (you guessed it) Names (fName (primary) and
flocation). The tMain holds reporting records (fRecordID,
fName, fSales, etc). What I want to see is a count of
records based on the Names. I can do this where
tMain.fName = tNames.fName but it doesn't show the
tnames.fNames that don't have any records in tMain (I.e.
the count would be 0). How would I get the query to show
me those as well so I can track who is NOT using the
system?
 
Back
Top