>Dragan,
>
>On a similar subject I have been using ALTER TABLE after a SELECT to get rid of columns I don't want. I always wished there was a command like SELECT * EXCEPT Table1.MyField...
>
Actually a SELECT using only the fields you need would be faster than a SELECT *. Some backends actually take quite a long time to process the "*" into a field list.
It would definitely be faster than doing the SELECT * and ALTER TABLE to remove the columns later.
>Instead of listing each field in the SELECT, I sometimes do
>
>SELECT * FROM orders INNER JOIN ordItems ON orders.order_id=ordItems.order_id INTO CURSOR MyCursor
>USE (DBF()) AGAIN IN 0 ALIAS ReadWrite
>USE
>ALTER TABLE ReadWrite DROP COLUMN order_id_b
>ALTER TABLE ReadWrite RENAME COLUMN order_id_a TO order_id
>
>