There will be 1 S and 1 E record for each compartment. The "corresponding" A record will only exist if the compartment was measured. So even if there are 4 compartments with S records but those same compartments only have 2 A records, I only want return those A records.

Does that answer your question?