set nocount on
declare @one table (oneid int, oneval varchar(10))
declare @many table (oneid int, manyval char(1))

insert @one
select 1, 'one' union
select 2, 'two' union
select 3, 'three'

insert @many
select 1, 'a' union
select 1, 'b' union
select 1, 'c' union
select 2, 'a' union
select 2, 'b'

select * from @one
select * from @many

--straight select with outer join
select	a.oneval
	,b.manyval
from	@one a
left outer join @many b on a.oneid = b.oneid

--aggrate with group by
select	a.oneval
	,max(b.manyval) maxManyVal
from	@one a
left outer join @many b on a.oneid = b.oneid
group by a.oneval