>>Hi could someone clarify for me if its possible to control the Group By clause of a select statement (ordering doesn't seem to alter the results.
>>
>>If my select produced:
>>
>>Field1 Field2
>> 1 a
>> 1 b
>> 2 b
>> 2 a
>>
>>After a group by on Field1 how can I get the result to be:
>>
>>Field1 Field2
>> 1 a
>> 2 a
>>
>>Thanks in anticipation.
>
>Caroline,
>What logic outputs like that ? Is that sort on first col then on 2nd ? If so 'simple' group by needs 2 SQL :
>
>select * from mySource order by 1, 2 desc into cursor crsTemp nofilter
>select * from crsTemp group by 1
>
>Cetin
Cetin the above is a partial result not ordered or grouped that I then want grouped so that I only have 1 entry for each Field1 key. Ideally I would like to order it so that the results will show 'a' in field2 if there was both an 'a' and 'b' collected.
Does that make any more sense?
This is my select statement.
SELECT ;
FROM links;
WHERE Links.itype IN(2,1);
GROUP BY links.iwork
Caroline