Hey, John
beat you by 2 seconds ;)

Arnon
>
>In VFP, this would accomplish the task:
>
>SELECT * FROM product_tbl INTO TABLE products_tmp
>
>
>>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