>SELECT Master.Numero,Master.FirstName,Master.LastName,Master.Born,Master.Decease,Master.BornYear,Master.DeceaseYea,Master.NoSchool, > Master.NoMaster,MasterType.Title_E,MasterType.Title_F,Master.WikiUrl_E,Master.WikiUrl_F,Master.WikiTitl_E,Master.WikiTitl_F,; > IIF(ISNULL(MasterDefinition.Notes_E),"",MasterDefinition.Notes_E) AS Notes_E,; > IIF(ISNULL(MasterDefinition.Notes_F),"",MasterDefinition.Notes_F) AS Notes_F,Master.Url; > FROM Master; > LEFT JOIN MasterDefinition ON Master.Numero=MasterDefinition.NoMaster AND MasterDefinition.NoMasterC=14; > INNER JOIN MasterType ON Master.NoMasterT=MasterType.Numero; > WHERE Master.Numero=41; > ORDER BY Master.LastName,Master.FirstName >>