Appending data from another table in base
How can I append data from another table in base. Both the tables have common on fields. SQL syntax will be useful.
First time here? Check out the FAQ!
How can I append data from another table in base. Both the tables have common on fields. SQL syntax will be useful.
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
Asked: 2021-01-03 07:10:49 +0100
Seen: 22 times
Last updated: Jan 03
arabic language support [closed]
Any way to speed up database search? [closed]
Installation on Fedora 14 system fails. [closed]
converting perfect works data files [closed]
Where can I find sample databases for Base?
compatibility with microsoft access97 [closed]
How do you set up input for many-to-many intersections in Base? [closed]