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