Lose the quotes, add a semicolon, and you already have
the correct syntax :-)
--- Jason <jzhu(at)dental(dot)temple(dot)edu> 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