union query

• smknox

  Hall of Fame

  Points: 3275

  More actions

  April 30, 2008 at 4:28 pm

  #206826

  In the following union query how do I order by ProviderNameLF ?

  SELECT TOP 100 PERCENT

  p.PartyID

  ,p.LastName + ', ' + p.FirstName

  AS ProviderNameLF

  FROM

  dbo.Person p

  UNION

  SELECT TOP 100 PERCENT

  o.PartyID

  ,o.OrganizationName AS ProviderNameLF

  FROM

  dbo.Organization o

• Michael Valentine Jones

  SSC Guru

  Points: 64818

  More actions

  April 30, 2008 at 4:34 pm

  #809367

  Both of these should work

  ... rest of query...

  order by

  ProviderNameLF

  or

  ... rest of query...

  order by

  1

• smknox

  Hall of Fame

  Points: 3275

  More actions

  April 30, 2008 at 5:28 pm

  #809378

  thanks! It works.

  Sam