combining two tables with similar structure

• Jeffrey Chow

  SSC Veteran

  Points: 270

  More actions

  August 29, 2005 at 2:13 pm

  #94713

  Hi,

  I'm trying to write a SELECT statement to retrieve users from two tables. The structure is as follows:

  activeUsers

  userID, firstName, lastName, pwd, activeSince

  'jacob888', 'Jacob', 'Bruno', 'password', 09/24/2004

  inactiveUsers

  userID, firstName, lastName, pwd, activeSince, inactiveReason, inactiveSince

  'neurologist', 'Brian', 'Jennings', 'protected', 01/18/2004, 'stole from colleagues', 03/09/2005

  I just want to get a list of all the userIDs, firstNames and lastNames. How do I do this?

  Thanks in advance!

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  August 29, 2005 at 2:15 pm

  #585978

  Select userID, firstName, lastName from dbo.ActiveUsers

  union all

  Select userID, firstName, lastName from dbo.InactiveUsers