Hello group,

I would like to add all of the rows from cisstudemo a temporary table into the permanent table studemo. This was an example INSERT INTO studemo ( SELECT * FROM cisstudemo) that gives me an error
Server: Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'SELECT'.
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near ')'.
How do I best accomplish my goal?

Jim