having problem in creating table from another table

Use this

SELECT *
INTO new_table_name [IN externaldatabase]
FROM old_tablename

Read:

http://www.w3schools.com/sql/sql_select_into.asp

---

Many Thanks & Best Regards, Hua Min