table join trouble

[Edward Corbett]

Hi,

 

I am trying to join a bunch of tables together. I want a row for each
"learner", and on the row, I want some "user", "centre", "client" and
"centreManager" information if there is any. Thus, I am trying to outer join
from the "learner" table to 4 other tables. The query I have so far is below
but it is returning 0 rows where I know that learner 215 exists and it
should return a line with the "l1" information on it. Any help would be very
much appreciated.

 

select

    `vPamUser`.`initials`,

    l1.`learnerId`,

    l1.`usedName`,

    l1.`fullFirstNames`,

    l1.`surname`,

    `vPamCentre`.`centreName`,

    `vPamCentreManager`.`managerName`,

    `vPamCentreManager`.`managerUsedName`,

    `vPamClient`.`clientShortName`

from 

     `vPamLearner` l1 left join vPamUser on l1.`assessorId` =
`vPamUser`.`userId`,

     `vPamLearner` l2 left join vPamCentre on l2.`centreId` =
`vPamCentre`.`centreId`,

     `vPamLearner` l3 left join vPamClient on l3.`clientId` =
`vPamClient`.`clientId`,

     `vPamLearner` l4 left join vPamCentreManager on l4.`centreManagerId` =
`vPamCentreManager`.`centreManagerId`

where

      l1.`learnerId`  =  215

  and l1.learnerId = l2.learnerId

  and l1.learnerId = l3.learnerId

  and l1.learnerId = l4.learnerId

;