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


>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.