select a.ID, a.Name,
max(case when b.ID = '01' then b.MODIFIER else '' end) as [MODIFIER_1],
max(case when b.ID = '02' then b.MODIFIER else '' end) as [MODIFIER_2],
max(case when b.ID = '03' then b.MODIFIER else '' end) as [MODIFIER_3]
from TableA a inner join TableB b
on a.ID = b.ID_NAME
group by a.ID, a.Name
KH
Choice is an illusion, created between those with power, and those without.
Concordantly, while your first question may be the most pertinent, you may or may not realize it is also the most irrelevant
Cross-tab or Pivot... How can I do it?
Forum Locked
Posted - 03/17/2006 : 08:26:22
