SELECT pr.ProgramDesc, d.DesignationAmount, n.NameID, n.DisplayName, n.AddressLine1, n.AddressLine2, n.City, n.State, n.Zip
FROM
  camNamesV n,
  camPledges pl,
  camDesignations d,
  camPrograms pr,
  camAppeals a,
  camYears y
WHERE
  n.NameID = pl.NameID and
  pl.PledgeID = d.PledgeID and
  d.ProgramID = pr.ProgramID and
  pl.AppealID = a.AppealID and
  y.YearID = a.YearID and
  y.YearDesc = '2006'
ORDER BY
  pr.ProgramDesc, d.DesignationAmount DESC