Hi Arnon ---

ROFL!!! We seem to be picking the same questions, eh?


>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