Posted by Brian Parker on 10/01/50 11:42

Appreciate it - worked great.
-BEP

Doug wrote:
> SELECT
> a.Name,
> SUM( isnull(c.amount,0) ) as Total
> FROM
> FROM
> Event a left outer join
> Transaction b on a.EventID = b.EventID
> left outer join
> Amounts c on b.TransID = c.TransID
>

• Next in forum: Re: Selecting records by date - need a little help
• Prev in forum: Re: Finding the natural key
• Thread view: Re: Not grasping outer joins for ms-sqlserver :: 3 tables to join

[Reply to this message]