• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 917
  • Last Modified:

MySQL INNER SELECT with multiple records... help?

Ok - this is slightly confusing so bear with me

Imagine a select query - simple, returns one line per record.

Now, add an inner select into that query, that may return multiple records.

Is there any way to get the (possibly) multiple records to show up as additional fields in the resulting set of the main (parent/top/whatever) query rather than duplicating recordsets to account for multiple records returned from the inner query?
1 Solution
If I understood, you could use group_concat to return several values as a simple string.

Is my guess even close?
trickyidiotAuthor Commented:
I got past this myself - need to close the question so I'm giving you the points

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now