Re: Insert values from one existing table into a new table.

Lose the quotes, add a semicolon, and you already have
the correct syntax :-)
--- Jason  wrote:
> I want to insert the existing values of one table
> into a new table.  It
> needs the combination of  these to sql commands:
> 
> "  insert into new_table values (
> values_of_AtrributeA,
> values_of_AttributesB) "
> " select AttributeA, AttributeB from some_table "
> 
> Thanks for your suggestions!  -- Jason
> 
> 
> 
> 
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster


__________________________________________________
Do You Yahoo!?
Find the one for you at Yahoo! Personals
http://personals.yahoo.com