> Many thanks for the replies.
>
> I knew it must be something simple!!
>
> Cheers,
> R.
> insert into combined_table
> select * from table0
> union
> select * from table1
Note that 'union' will eliminate duplicate rows. Use 'union all' instead
if you don't want this.
Many thanks for the replies.
I knew it must be something simple!!
Cheers,
R.
-Original Message-
From: John LeSueur [mailto:[EMAIL PROTECTED]
Sent: 31 January 2005 21:27
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] joining a table to the end of another table
Richard Boyd wrote
At 9:05 PM + 1/31/05, Richard Boyd wrote:
See example below if it's not clear what I'm looking to do:
Table 0 Table1
0 | A 5 | F
1 | B 6 | G
2 | C 7 | H
3 | D
4 | E
Combined table
0 | A
1 | B
2 | C
3 | D
4 | E
5 | F
6 | G
7 | H
I'm
Other database engines provide methods of doing this, but I
don't think sqlite does. I would use an insert statement that uses
select to copy the content of one table into the other.
insert into X(field1,field2) select field1,field2 from Y
--- Richard Boyd <[EMAIL PROTECTED]> wrote:
> Hi,
>
4 matches
Mail list logo