There 2 tables in my tables
- contacts (Fields : firstname, lastname, id)
- phone numbers (Fields : number, id, contact_id)
The result i am looking for is as below.
Firsname Lastname Phone numbers
XYZ ABC Array of numbers
I tried inner join query but it shows me separate result for same contact_id. I tried to use group_by but no luck.
Aucun commentaire:
Enregistrer un commentaire