I have two tables SALES AND PAYMNENT. SALES have the follwing fields CUSTOMER, INVOICE_DATE, INVOICE_NUMBER, AMOUNT. PAYMENT have the following field PAYMENT_DATE, RECEIPT_NUMBER, RECEIPT_AMOUNT, INVOICE_DATE, INVOICE_NUMBER. The two tables are linked by the INVOICE_DATE. I want to make a selection base on month and year of the Invoice date such that it would give me all sales made within the selected period and ONLY respective receipt within the selected period specifically for the selected sales. That is all receipts collected where the selected INVOICE MONTH and YEAR is the same as the RECEIPT MONTH AND YEAR .
I am confused as to how best to link the two tables. And also whether this would involved the SET ANALYSIS.
