Count

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

Guest

Okay, I have a quick question. I have a summation query, where it's supposed to count how many people are attending an event. When I use just the attendance table, where I did a group by using the conferenceID and count the PersonID, I have 80 people. However, if I link the attendance table with the person table, I get 79, which is the correct count. Does anyone know why?
 
Both could be correct. It may be that one of the personIds from the
conference could've been deleted from the Person table.. if you have
referential integrity off that can easily happen.

--
Kailash Kalyani
MEA Developer Support Center
ITWorx on behalf of Microsoft EMEA GTSC

anthony said:
Okay, I have a quick question. I have a summation query, where it's
Click to expand...
supposed to count how many people are attending an event. When I use just
the attendance table, where I did a group by using the conferenceID and
count the PersonID, I have 80 people. However, if I link the attendance
table with the person table, I get 79, which is the correct count. Does
anyone know why?
 
Back
Top