Ciao,

ho scritto questa istruzione SQL:

"SELECT
ShowsPictures.ID,
ShowsPictures.Show,
ShowsPictures.LinkToWork,
Works.*,
Artists.ID,
Artists.Surname,
Artists.Name
FROM
ShowsPictures
LEFT JOIN
(Works
INNER JOIN Artists ON Works.Artist=Artists.ID) ON ShowsPictures.LinkToWork=Works.ID WHERE ShowsPictures.Show='"&intShowID&"' AND ShowsPictures.PicOnShowsList=True"