Append One Table To Another

From: Johnmichael Monteith (jpmonteith_at_psfinc.com)
Date: 03/17/04


Date: Wed, 17 Mar 2004 06:34:04 -0800

I want to append records from one table to another - and I suspect this is
simple to do, but am having difficulty getting there.

Example:

Table 1:
ID, Data
1, This is a test
2, Mary had a
3, A funny thing happened

Table 2:
1, of the emergency broadcasting system.
2, little lamb.
3, on the way to work.

I would like to know a way to combine these so it is:

1, This is a test of the emergency broadcasting system.
2, Mary had a little lamb.
3, A funny thing happened on the way to work.

Thank you so much!!



Relevant Pages

  • Append One Table To Another
    ... I suspect this is ... This is a test of the emergency broadcasting system. ... Mary had a little lamb. ... A funny thing happened on the way to work. ...
    (microsoft.public.sqlserver.programming)
  • Re: Append One Table To Another
    ... "Johnmichael Monteith" wrote in message ... This is a test of the emergency broadcasting system. ... Mary had a little lamb. ... A funny thing happened on the way to work. ...
    (microsoft.public.sqlserver.programming)
  • Re: Append One Table To Another
    ... Columnist, SQL Server Professional ... This is a test of the emergency broadcasting system. ... Mary had a little lamb. ... A funny thing happened on the way to work. ...
    (microsoft.public.sqlserver.programming)
  • Re: A Party for 144.......
    ... number of halal dishes, and to make obvious the dishes which were haraam ... The neck bones and most of the scraps were made into a lamb ... I had not noticed this poster before but it is a rather funny post ... When I read it it was a tad funny as obviously the person whover is ...
    (rec.food.cooking)
  • Re: Found out MCSE will be faced out in 2008. whats the alternative th
    ... He was a funny b@stard. ... tru dat. ... Mary had a little lamb. ... The doctor was quite surprised! ...
    (microsoft.public.cert.exam.mcse)