Add a custom row to a select result set

• mattech06

  SSCrazy

  Points: 2484

  More actions

  February 19, 2014 at 6:13 am

  #304330

  Hi,

  I have this simple select statement

  Select Distinct EPSReferralKPIs.dbStaffLastName

  From EPSReferralKPIs

  Is it possible to add another row onto this result set which is simply dbStaffLastName = 'No Ref - Staff'?

  thanks,

• djj

  SSCoach

  Points: 18831

  More actions

  February 19, 2014 at 6:18 am

  #1690228

  Select Distinct EPSReferralKPIs.dbStaffLastName

  From EPSReferralKPIs

  UNION ALL

  SELECT 'No Ref - Staff'