This is my database. link
I'm trying to make a query that shows images and names of artists and I also want to get a list of all the songs or singles, all in the same query.
SELECT a.* FROM discografica.cancion a
INNER JOIN discografica.singles b ON b.idsingles = a.idsingles
INNER JOIN discografica.grupo c ON c.idgrupo = b.idgrupo
INNER JOIN discografica.grupo_artista d ON d.idgrupo = c.idgrupo
INNER JOIN discografica.artistas e ON e.idartistas = d.idartistas
INNER JOIN discografica.gestion f ON f.idartistas = e.idartistas
INNER JOIN discografica.personal g ON g.idpersonal = f.idpersonal
I have this done but I do not know if it's okay, and I can not implement it to show the name and image of the artist. Thanks