Merge tables

[efratushava]

Hi,
Can I somehow merge two tables together?

Thank you

[tobimensch]

If they contain compatible data, that shouldn't be a problem.

Have you read the manual?
http://tobimensch.github.io/termsql/

I think the -a option for not dropping the tables should be interesting for you.

The -o option for writing the database to a file should be equally interesting to you.

Now try to combine those two and you should be able to create a permanent database
where you can add data as you wish, with termsql, but also other tools.

If you mean merging data that is only partially compatible, then I think there's no support for that.

[ayoubfalah]

Hi,
Assume we have two tables R1 and R2 with the following schemas:
R1(A1, A2)
R2(A2, A3)
Is it possible to join R1 and R2 using termsql ? in SQL I achieve it using the following query:
SELECT * FROM R1, R2 WHERE R1.A2 = R2.A2

thanks in advance!