>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; > INNER JOIN ON Master.NoMasterT=MasterType.Numero; > JOIN ( ; > SELECT NoMaster AS Numero FROM Style; > UNION SELECT NoMaster2 AS Numero FROM Style) temp ; > ON Master.Numero=Temp.Numero ; > ORDER BY LastName2,FirstName2 >Thanks, I used Fabio's approach. It does the same thing.