In order to migrate to a new ERP system i need to recover data from an old tkSQLite database. I am not an SQL expert and am having problems :
I have 2 tables:
Table1
person_id, name, firstname
Table2
person_id, telephone_numbe r
Each person can have several telephone numbers in Table2. What I need to do is select each person and their telephone number(s) on 1 row.
...