I have 2 tables with invoices and receipts documents from 2 months - May and June, having same fields structure (doc no, doc date, customer name, customer ID, value etc.), and I want to compare them as below
1. "Closed docs" - only documents from May file which aren't in June file;
2. "New docs" - only documents from June file which aren't in May file;
3. "Open docs" - only documents which exists in May and June files.