I did get the browse as follow:

CODE C_1 C_2 C_3
0001
0002
0003

The browse table is empty. The descriptions are not there. Any idea what is wrong.

My data is as follow, just a reminder

CODE SIZE DESCRIPTION
0001 1 S
0001 2 M
0001 3 L
0002 1 M
0002 2 L
0003 1 M



Tai SC


>>Sorry, I am using FPW26 and if I use the SQL, I end up getting the same data. If I have duplicate code+size, it will probably eliminate it.
>>
>>Tai SC
>>
>
>Looking at the output you wanted, it does not look like you want counts. So duplicate records not being included should not matter. Carl's solution should still work unless you are trying to count something.
>
>>
>>>Using the built-in VFP5.0a query designer, I ended up with the data the way you pictured it, except the 1, 2, and 3 were shown as C_1, C_2, and C_3. I know there's a way to get it back to what you want, but I can't think what it is this late. :)
>>>
>>>However, the SQL code to get that data doesn't seem to care that it's not numeric:
>>>
>>>SELECT *;
>>> FROM size;
>>> GROUP BY Size.code, Size.size;
>>> ORDER BY Size.code, Size.size;
>>> INTO CURSOR SYS(2015)
>>> DO (_GENXTAB) WITH 'Query1'
>>>BROWSE NOMODIFY
>>>
>>>Give it a shot, it worked for me.