[thelist] SQL Query Help

[Tab Alleman]

UNION with a query that returns "Agencies" that do not meet the criteria?

> -----Original Message-----
> From: thelist-bounces at lists.evolt.org
> [mailto:thelist-bounces at lists.evolt.org]On Behalf Of Michael Pack
> Sent: Wednesday, March 01, 2006 11:40 AM
> To: thelist at lists.evolt.org
> Subject: [thelist] SQL Query Help
> 
> 
> Hi all, I'm stuck a bit and drawing blanks.
> 
> My query is...
> 
> SELECT     COUNT(dbo.tbl_audit.update_stamp) AS ComplianceData,
> dbo.tbl_audit.fkFacilityId, dbo.tbl_facility.txtAgencyName,
> dbo.tbl_facility.name, 
>                       dbo.tbl_facility.id
> FROM         dbo.tbl_audit INNER JOIN
>                       dbo.tbl_facility ON dbo.tbl_audit.fkFacilityId =
> dbo.tbl_facility.id
> WHERE     (dbo.tbl_audit.update_stamp >= '20060201') AND
> (dbo.tbl_audit.update_stamp < '20060228') AND 
>                       (dbo.tbl_audit.update_stamp -
> CAST(FLOOR(CAST(dbo.tbl_audit.update_stamp AS float)) AS datetime)
> BETWEEN '00:00:00:000' AND '10:00:01:000')
> GROUP BY dbo.tbl_audit.fkFacilityId, dbo.tbl_facility.txtAgencyName,
> dbo.tbl_facility.name, dbo.tbl_facility.id
> 
> This returns the records starting at 1, showing me the "Agencies" that
> meet the criteria. How would grab and return the records that have a 0
> COUNT within the same query? I need to show the "Agencies" 
> that have not
> met the criteria as well.
> 
> TIA
> 
> 
> -- 
> 
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
> 
> For unsubscribe and other options, including the Tip Harvester 
> and archives of thelist go to: http://lists.evolt.org 
> Workers of the Web, evolt ! 
>