Merging 2 columns from 2 databases

• Sarah Illouz

  SSC Enthusiast

  Points: 107

  More actions

  June 27, 2005 at 5:40 am

  #362988

   

  Hey people!

  Does anybody know how to merge 2 columns together from two different tables or even more from two different databases?

   

  Say I have the databases Sarah_1 and Sarah_2

  and I want to take a column from Sarah_1 and add it to an already existing table in Sarah_2 without overwriting the Sarah_2 data???

  HOW can this be done!! I need you experts to help!!!

  TAKE CARE

  Sarah

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  June 27, 2005 at 5:50 am

  #568534

  Please do not cross-post questions to different forums. We read all of them.

  Continue the discussion in http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=194238.

  --
  Chris Hedgate http://www.hedgate.net/
  Contributor to the Best of SQL Server Central volumes
  Articles: http://www.sqlservercentral.com/columnists/chedgate/