Reply to Re: Not grasping outer joins for ms-sqlserver :: 3 tables to join
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
>