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