>I want to create a new table using all fields of another table
>
>create table products_tmp as;
>select * from products_tbl
>
>The syntax is wrong ????????
>I am working from an ansi standard sql book and I'm stuck !!!!!!
>
>any sample code of other sql basic commands would be great and save me many frustrating hours.
>
>Best wishes
>Colette
One way to do it is to use:
SELECT * FROM products_tbl INTO TABLE products_tmp
If you want the tbale to be empty:
SELECT * FROM products_tbl INTO TABLE products_tmp WHERE .F.
Bill
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.