>When doing it with VFP code, I was using two SQL to obtain the desired data. Basically, I was getting one cursor from unions for the first SQL like this:
>
>

>SELECT NoMaster AS Numero FROM Style;
> UNION SELECT NoMaster2 AS Numero FROM Style;
> GROUP BY 1 INTO CURSOR Temp
>lcInnerJoin='INNER JOIN Temp ON Master.Numero=Temp.Numero'
>

>
>And, then, on the second SQL, I was simply evaluating lcInnerJoin to get the data such as:
>
>

>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;
> &lcInnerJoin ORDER BY LastName2,FirstName2
>

>
>Now, I need to merge that code into one SQL in order to be compliant with a client server approach for a future expansion to SQL Server. The inner join is not a problem but I am looking for the best approach in regards to the union clause.

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