hi,

how would i select something from one table and put it into another, ie select name from details table and insert it into friends table? can it be done in one statement, i'm lost?!!

thanks alot

A lot depends on how you define "one statement", but you can certainly use:to take one copy of each name from the details table and place them into the friends table.

It is your call as to whether that is one compound statement, or two atomic statements. From an execution standpoint, they are a single statment executed by the SQL engine. From a syntax standpoint, they are two separate statements that are executed as one.

-PatP

well i dont mind one or two statements either way as long as it works