>Try with derived table
>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.
