# One to Many
**URL:** https://discuss.elastic.co/t/one-to-many/111363
**Category:** Logstash
**Created:** [December 12, 2017, 2:44pm UTC](https://discuss.elastic.co/t/one-to-many/111363 "2017-12-12T14:44:35Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@rnicholls](https://discuss.elastic.co/u/rnicholls)
#### Post date: [December 12, 2017, 2:44pm UTC](https://discuss.elastic.co/t/one-to-many/111363/1 "2017-12-12T14:44:35Z")
Hello,
I am trying to figure out how to do a one to many relationships. I am using JDBC and I have tried to do it via aggregate but can't figure it out.
All I am trying to do is.
{
id: "1"
title: "Batman v Superman"
genre: {
id: "1"
"name": "Action"
}
}
The movie, and genre(s) are in two tables. I just want to join them together and have the join be an array of objects.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [January 9, 2018, 2:44pm UTC](https://discuss.elastic.co/t/one-to-many/111363/2 "2018-01-09T14:44:46Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.