Hello all,

Suppose I have a table in my database. This table, along with other fields contains the following fields: [manifest_id], [warehouse_id] and [process_status] (they are not primary keys). I want to get a count of all records that contain a specific mainfest_id AND warehouse_id, then within this subset of records, I want to find out how many records have the [process_status] field = 'A'.

In other words, how do I write a select query string that returns both the counts where the 1st count is the number of records that sastified one condition and the 2nd count is the number of records within the 1st record subset that sastified another condition?

My aim is to get a ratio of of records with process_status = 'A' from all records that have a specific manifest and warehouse id.

Any help is greatly appreciated.