I need to convert two VFP SQLs into SQLExec(). What I have presently in VFP is one SQL which collects all primary keys from a table. Then, from that cursor, I extract all the necessary fields from the table by the use of a inner join. So, I have something like:

SELECT MIN(News.Numero) AS Numero FROM News WHERE Priority INTO CURSOR Temp

SELECT News.Numero,News.CustomerName FROM Temp;
 INNER JOIN News ON Temp.Numero=News.Numero INTO CURSOR Temp

Basically, how can I achieve the same from a SQL Server table by the use of SQLExec()?