Appending data from another table in base

[MHRao]

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

[gkick]

Hi,

Maybe this link might be of help

How to update fields in base from another table?

I would like bring in data from one table to another. I have two tables, “Calendar1” and “Calendar2”, these two tables are joined on the field “ID1” “ID2” (I do not know if the joined relationship is correct. I would like to copy information from the field “Event1” in Calendar1 to “Event2” in Calendar in those cases where “event2” has currently no data. I have tried this UPDATE “Calendar2” SET “Event2”= “Calendar1”.“Event1” WHERE “Calendar2”.“Event2”=NULL This doesnt work. Even if I simplif…

[Ratslinger]

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