Thanks a lot for your response. Yes i want it like the second one. I have got the following records from the dump.
This is a record from release table
2001185 Yordano & Franco de Vita 2 2 2017-05-15 15:35:17.613531+00
And this is a record from artist_credit table
202094 Ani & Beau 1 6 2011-05-16 16:32:11.963929+00
How do i get their relationship? I thought “202094” in the artist credit was the id from the release table but its not. So how do i connect them. My end goal is to have a tuple like