tibberous Posted December 14, 2009 Share Posted December 14, 2009 I have two tables, users and phoneNumbers. A user can have any amount of phone numbers. I was to select all of a users phone numbers for a user, as a comma separate field. So, if Joe was my users name, and have 3 phone numbers, my recordset would look like: id: 4 name: Joe phoneNumbers: 555-5555, 567-7890, 754-9000 I was thinking something like: select `id`, `name`, (select --- from phoneNumbers where phoneNumbers.owner=users.id) as `phoneNumbers`from users where `name`='Joe' Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.