>SELECT DISTINCT Partida.Name AS Name, Results.Partida; > FROM Results; > LEFT JOIN Partida ON Results.Partida == Partida.Kod; > ORDER BY Results.Partida; >INTO CURSOR cEl > >
SELECT Partida.Name AS Name, Results.Partida; FROM Results; LEFT JOIN Partida ON Results.Partida == Partida.Kod; GROUP BY 2,1; INTO CURSOR cEl