>>I forgot to mention something important (here in the initial message). I am copying record from a table of one database to a table in another.
>>
>>And the syntax I used was:
>>
>>
>>insert into MyTable1( field1, field2, field3) select field1, field2, field3 from AnotherDb..MyTable2
>>
>>
>>Do you see what is wrong with the above?
>
>
>Dmitry....what is the error message?
>
>Note that sometimes you can get the red squiggly underline because of the intellisense cache
>
>So again...what is the error message you're getting?
The error is that the AnotherDb..MyTable2 is invalid object. And the column names have squiggly underline.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
