Left Join in a subquery not working in access 2010 - Microsoft Community

The query starts off with the People table SELECT People.ID, People.aacode, People.PERSNO, People.HRP, People.DVHsize, //then there is some unrelated fields followed by the subquery (SELECT Relatives.Relationship FROM Relatives LEFT JOIN ...

answers.microsoft.com