Append One Table To Another
From: Johnmichael Monteith (jpmonteith_at_psfinc.com)
Date: 03/17/04
- Next message: Tibor Karaszi: "Re: How to find only updated columns in a trigger."
- Previous message: CCA Dave: "Re: counting with reset at group by? change"
- Next in thread: Tom Moreau: "Re: Append One Table To Another"
- Reply: Tom Moreau: "Re: Append One Table To Another"
- Reply: Tibor Karaszi: "Re: Append One Table To Another"
- Reply: Keene: "Append One Table To Another"
- Messages sorted by: [ date ] [ thread ]
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!!
- Next message: Tibor Karaszi: "Re: How to find only updated columns in a trigger."
- Previous message: CCA Dave: "Re: counting with reset at group by? change"
- Next in thread: Tom Moreau: "Re: Append One Table To Another"
- Reply: Tom Moreau: "Re: Append One Table To Another"
- Reply: Tibor Karaszi: "Re: Append One Table To Another"
- Reply: Keene: "Append One Table To Another"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|