sql server 2005 - SQL 'simple' query syntax error - help! -

my query returns syntax error:

invalid object name 'table.clientinfo'.

here query:

insert table.clientinfo (name, addr, entry, affiliate )  select name, addr, entry, affiliate table.clientinfo product = 5 

is error due insert function not finding 'clientinfo' not exist.

can give me correct syntax create table first before populating select function?

you want create table

create table clientinfo (          name varchar(100)          addr varchar(100)          entry varchar(100)          affiliate varchar(100)        ); 

with specific types/sizes app. might want indicate foriegn , primary keys, constraints etc too