Posted by Doug on 10/01/90 11:42

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: Finding the natural key
• Prev in forum: Re: Data Warehouse Nulls
• Thread view: Re: Not grasping outer joins for ms-sqlserver :: 3 tables to join

[Reply to this message]