Please disregard the previous email. After rereading what you sent, I realized
that I need an outer join to A2 and not simply a self join...thanks and my
apologies!
- Original Message
From: Tom Lane <[EMAIL PROTECTED]>
To: Heikki Linnakangas <[EMAIL PROTECTED]>
Cc: Marcus Torres <[EMAI
I respectfully challenge that the aggregation is correct.
In the where clause, I specify A2.AUDIT_TYPE_CODE = CONTENT_2, thus returning
only 2 rows for A2 and not all of the rows in A2 which happen to have a
TXN_COUNT of 1 / row but could in fact be any positive number. I used 1 for
simplici
