|
A table has the following columns (amongst others) Transaction_ID Type Debit Credit Nominal_Code Log_Time All rows are posted in pairs (Debit = value and Credit = 0) and (Debit = 0 and Credit = value) so the log-time should be the same for both rows I'm trying to return records where Type = 'BR' or 'BP' and Nominal_Code is the same for both the first and second rows (and all subsequent pairs)... I'm struggling to think of a way to returning those values, probably based on the log-time being the same for the two rows Might have over complicated that description (it's Friday). Really returning any records where Nominal_Code is the same for any two rows that have the same log_time is the bit that's confusing me. Any ideas? Thanks |
|
This has NOT been tested... SELECT "***** t1 columns: ',
t1.*,
"***** t2 columns: ',
t2.*
FROM t AS t1
INNER JOIN t AS t2
ON t1.Transaction_ID <> t2.Transaction_ID
AND t1.Log_Time = t2.Log_Time
AND t1.Nominal_Code = t2.Nominal_Code
ORDER BY t1.Log_Time;
|
