Nested JOIN

[Tom.Xmas]

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

I wrote this SQL instruction and it does work with a RIGHT JOIN or a INNER JOIN as second Join (in bold), but doesn't with a LEFT JOIN (which is what I need).

I'm not expert enough to understand why!

Any idea?

Thanks.