i've got a super intriguing SQL question to ask - at least for me it's tremendously interesting.
i've got a query that produces data for reconciliation. (kindly see attached excel sheet here joining.xlsx
in it i have some credits that have a matching debit and some that don't. the 2 yellow rows in the below picture show a match.
the rules are that for 2 records to match, their:
wID must be the same
2) Credit and Debit must be the same (though they're on different lines)
3) Source must be different
4) ReconciliationAccountID must be the same
5) MachineID must be the same
so i've got 2 matching records as shown in the yellow highlight. how do i join these 2 into a single table that shows this?
the matched records are on 1 line and the unmatched records are as per normal also on one line?