Search results

I have a query that is pulling compliance for every department. The table I am querying uses a look-up table for the service name. My table does not have data for every department, but I want my query to return every department whether they have data or not and to mark them as zero. Any ideas...