samedi 3 octobre 2015

Merging datas using SQLite

i am trying to find a way to merge datas in a sqlite database using the cli.

example :

TABLE1 with col1(keys) & col2 (values1)
col1;values1
1234;456
1235;789

TABLE2 with col1(keys) & col2 (values2)
col1;values2
1233;235
1234;457
1235;790

Target :
TABLE3 with col1(keys) & col2 (values1) & col3 (values2)
col1;values1;values2
1233;NULL;235
1234;;456;457
1235;789;790

How can I do that in SQL ?

Aucun commentaire:

Enregistrer un commentaire