Re: [GENERAL] Outer Join help please

2003-09-19 Thread Manfred Koizar
On Fri, 19 Sep 2003 10:10:17 +0100, Rory Campbell-Lange <[EMAIL PROTECTED]> wrote: >The sent >column shows the number of items sent to each recipient from each >source. The received column [...] is summing the number of messages > by recipient [and] need to be filtered by source too. SELECT t_to A

[GENERAL] Outer Join help please

2003-09-19 Thread Rory Campbell-Lange
I'm having troube doing a left outer self join on a table. The sent column shows the number of items sent to each recipient from each source. The received column (generated by the outer join) is incorrect because although it is summing the number of messages by recipient, these need to be filtered