how to use the sql-left join ?

this sql is ok
SELECT NA.*, DV.YN_CODE, NA1.NA_COMPANY AS NA_1STNAME,NA.AW_LEVEL,
SPACE(30) AS MIG_OFFICE,NT.NT_TYPE,AN.AN_TYPE,AN.AN_WRKRID FROM TmpCurs_AllDonors2 NA
LEFT OUTER JOIN TmpCurs_AllDonors3 DV ON DV.CM_ID = NA.CM_ID
LEFT OUTER JOIN NAME NA1 ON NA.NA_COID1ST = NA1.NA_ID
LEFT OUTER JOIN NOTE NT ON NT.NT_ID = NA.CM_ID
LEFT OUTER JOIN ASSIGN AN ON AN.AN_ID = NA.CM_ID

then how can i add the filter condition for the note table ,for example
LEFT OUTER JOIN NOTE NT ON NT.NT_ID = NA.CM_ID and NT.NT_usage = 'X'
LEFT OUTER JOIN ASSIGN AN ON AN.AN_ID = NA.CM_ID

but when i add this condition ,it does work.how can i do?
thank you

[694 byte] By [jetsu] at [2008-3-5]