kiwiron
  • Member for 7 years, 7 months
  • Last seen more than a month ago
  • Kapiti Coast District, Wellington, New Zealand
Build JSON object from one-to-many relationship data in a single query?
1 votes

A join (on container_id) will work very well in this situation. Yes, you will get multiple rows with duplicated container data. If your coding language supports an ORM (e.g. MyBatis or Hibernate for ...

View answer