dimanche 21 décembre 2014

Merging multiple tables without duplicating IDs using SQLite

I am working on search interface and my problem is that the ids are all duplicating making the searched word go wrong. How can I merge multiple tables without duplicating ids?


Example:


Table1



_id ques long
1 hello tung
2 ask bung
3 bun hot


Table2



_id ques long
1 hind sling
2 scent pong
3 brun jit


Table3



_id ques long
1 pont rave
2 sue lace
3 brun bass


The output should be like this



_id ques long
1 hello tung
2 ask bung
3 bun hot
4 hind sling
5 scent pong
6 brun jit
7 pont rave
8 sue lace
9 brun bass

Aucun commentaire:

Enregistrer un commentaire