sage-
> 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:
>
> > Hi,
> >
> > Im inexperienced with database
> 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 su
Richard Boyd wrote:
Hi,
I’m inexperienced with databases so forgive me if this is a silly
question.
What I want to do is join to separate tables together into one table.
This is to enable me to synchronize databases held on remote systems.
I would use a master table which would have the dates o
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,
>
Hi,
I’m inexperienced with databases so forgive me if this
is a silly question.
What I want to do is join to separate tables together into
one table. This is to enable me to synchronize databases held on remote systems.
I would use a master table which would have the dates of each
7 matches
Mail list logo