[Solved] How can I do a three way join using a junction table?
The tables look like this
Artwork(title, artist, id)
Images(filepath, id, position)
art_image(artid, imageid)
I'm trying to do a three way join and select the artwork title, artist, and image with position 1. I looked at the documented examples but I was a little confused by the way nested selects work.
Artwork(title, artist, id)
Images(filepath, id, position)
art_image(artid, imageid)
I'm trying to do a three way join and select the artwork title, artist, and image with position 1. I looked at the documented examples but I was a little confused by the way nested selects work.
