Ask Your Question
0

Appending data from another table in base

asked 2021-01-03 07:10:49 +0100

MHRao gravatar image

How can I append data from another table in base. Both the tables have common on fields. SQL syntax will be useful.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2021-01-03 19:25:54 +0100

Ratslinger gravatar image

Hello,

It appears you want to copy records from one table to another. This is strange as you are then duplicating information and that is contrary to the benefits of using a relational database.

You also do not state the database you are using. SQL can vary. Knowing the from and to circumstances also is important.

Nothwithstanding all this, there is a brief Insert example in this post -> Inserting From one table to another along with a constant

Also it is always best to refer to the documentation of the database being used. Here is HSQLDB embedded -> HSQLDB v1.8

More specifically within that document is the Insert statement -> Insert

edit flag offensive delete link more
1

answered 2021-01-03 19:06:43 +0100

gkick gravatar image

Hi,

Maybe this link might be of help

https://ask.libreoffice.org/en/questi...

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2021-01-03 07:10:49 +0100

Seen: 22 times

Last updated: Jan 03