The problem is most likely that you are using an implicit cartesian join on
these three tables:
vvl_Counties ,
vvl_districts,
vvl_schools,
since they are not in the WHERE clause.
Remove them and you should get the desired results
With all those tables in there, you may be getting a lot more records than
you expected. Your current syntax will return a count of the number of
records in the joined structure, not a count of the number of unique
ChildID's. If that's what you want, change it to COUNT(DISTINCT
ChildIdentity.Chi
It's your FROM statement; you're not joining counties, districts, schools
and histories in any way, so you're getting a cartesian product set.
You need some join qualifiers along the likes of
vv1_Counties INNER JOIN vv1_districts on vv1_districts.countyID =
vv1_Counties.countyID (or whatever fi
3 matches
Mail list logo