Problem contructing SQL Request for multiple lines

[Kevin Moroney]

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_number


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.



For example if in Table1 I have

1, John, Mahony

and in Table2 I have

1, [phone]
1, [phone]
1, [phone]

What I need is a request which will give me:

John, Mahony, [phone], [phone], [phone]


If anyone knows how to do this I would be very greatful,

Thank you,
Kevin

[mwasif]

Use GROUP_CONCAT().