Task - gallery in one post and sql?

Question

SQL

Good afternoon !
Problem - there is a post in it unique id. name_post . desk
but each post has a gallery of pictures!
I could make a query that substitutes each post by id -
but how to make the pictures in the post - okay, one main picture for each post - it's easy,
but how to make a gallery of pictures in one post
so far got to JOIN joining tables, that is, a post with pictures have id and img_name and the post table from the post I take a unique id and compare it with the id from the img table something is still wrong because in these queries I was thinking ... I have a damn deadline and I don’t know what to do yet
If there is another way to sort through the pictures for each post, I will be glad to hear
if there is an answer to this option with sql, then I will also be very happy -
thanks

Answer 1

can be concatenated with grouping links to pictures, and parsed on the client.
and you can make a separate quick query to the table of pictures