>I have used VFPXTab a couple of times recently. It's very useful, though slow, which makes me wish there was some native SQL technique of accomplishing that. Basically, you know points in a table and need to create the table. For example, you know monthly sales for a not previously determined list of products and want to create a table with one row per month an one column per product.
>
>With the changes in SQL SELECT syntax in VFP9, especially the ones where you can include a select within the select, does anyone know of a technique to achieve similar results quicker?


Alex,

Take a look at FastXtab File #9944