>SELECT Master.Numero,Master.FirstName,Master.LastName,'MasterType.Title_A,MasterType.Title_F,Master.Bio_A,Master.Bio_F,; > UPPER(Master.LastName) AS LastName2,UPPER(Master.FirstName) AS FirstName2; > FROM Master; > INNER JOIN MasterType ON Master.NoMasterT=MasterType.Numero; > WHERE Master.Numero IN (SELECT NoMaster FROM Style); > OR Master.Numero IN (SELECT NoMaster2 FROM Style); >ORDER BY LastName2,FirstName2 >Thanks, this works well.