The syntax for an existing target table is:<br /><br />INSERT INTO &lt;target_table&gt; (&lt;column_list&gt<img src='/community/emoticons/emotion-5.gif' alt='' /><br />SELECT ......................<br />FROM ................<br /><br />The syntax you were trying can only be used to create a new table, without defining the table columns:<br /><br />SELECT .........<br />INTO &lt;new_table&gt;<br />FROM ...........<br /><br />For that purpose, it is preferred to do a CREATE TABLE and then use the INSERT INTO syntax.

About the formatting: do the indentations in Windows Notepad, then copy-and-paste into the forum.

Adriaan,
Let me try now as you suggested(copying format from notepad). I know I have asked this before and Frank suggested me to include []something[/] whethere left/right/center but never got it working.