Gerard,
How about...
SELECT MAX(Fld1),
MAX(Fld2)
FROM MyFile
GROUP BY Fld1
INTO CURSOR Temp
Hope this helps,
Gerard wrote -
I have a file as follows:
Fld1 Fld2
_____________________________
AA Widgets
AA
AA
AA
BB Spark Plugs
BB
BB
CC
CC Emeralds
DD
______________________________
I want to do following
Select * from MyFile Group by Fld1 into Cursor temp
.. but I want to ensure that I always get the description, if there is one in the result i.e. I need the following:
(I will only have spaces or the same value)
AA Widgets
BB Spark Plugs
CC Emeralds
I'm wondering is there a SQL way of doing this, or maybe some other way ?
Regards,
Gerard
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement