"Aleks" <arkark2004@hotmail.com> wrote in message
news:e4Lgt10BFHA.1392@tk2msftngp13.phx.gbl...
>I am trying to copy the values of one table to another one:
>
> Select ProdNum, Name,NYUSAPrice,MPN
> into ProductsQuartz [ProdNum,Name,Price,MPN]
> from productswithprice
>
> Both table already exist, trying to map the fields but I get an error ??
>
> A
>

"Aleks" <arkark2004@hotmail.com> wrote in message
news:O8mV950BFHA.3592@TK2MSFTNGP09.phx.gbl...
> Also tried:
>
> Insert into
> ProductsQuartz ('ProdNum','Name','Price','MPN')
> values ('productswithprice.ProdNum',
>

>
> But I get an error, this are fields from another table in the database,
how
> can I accoplish this ?
>
> A
>
>
>
> "Aleks" <arkark2004@hotmail.com> wrote in message
> news:e4Lgt10BFHA.1392@tk2msftngp13.phx.gbl...
> >I am trying to copy the values of one table to another one:
> >
> > Select ProdNum, Name,NYUSAPrice,MPN
> > into ProductsQuartz [ProdNum,Name,Price,MPN]
> > from productswithprice
> >
> > Both table already exist, trying to map the fields but I get an error ??
> >
> > A
> >
>
>

"AM" <shahdharti@gmail.com> wrote in message
news:uwvPX$0BFHA.2568@TK2MSFTNGP10.phx.gbl...
> Hi
>
> Insert into
> ProductsQuartz ('ProdNum','Name','Price','MPN')
> Select productswithprice.ProdNum,
> productswithprice.Name,productswithprice.NYUSAPrice,productswithprice.MPN
> from Productswithprice
>
> Hth
> "Aleks" <arkark2004@hotmail.com> wrote in message
> news:O8mV950BFHA.3592@TK2MSFTNGP09.phx.gbl...
>> Also tried:
>>
>> Insert into
>> ProductsQuartz ('ProdNum','Name','Price','MPN')
>> values ('productswithprice.ProdNum',
>>
> 'productswithprice.Name','productswithprice.NYUSAPrice','productswithprice.M
> PN')
>>
>> But I get an error, this are fields from another table in the database,
> how
>> can I accoplish this ?
>>
>> A
>>
>>
>>
>> "Aleks" <arkark2004@hotmail.com> wrote in message
>> news:e4Lgt10BFHA.1392@tk2msftngp13.phx.gbl...
>> >I am trying to copy the values of one table to another one:
>> >
>> > Select ProdNum, Name,NYUSAPrice,MPN
>> > into ProductsQuartz [ProdNum,Name,Price,MPN]
>> > from productswithprice
>> >
>> > Both table already exist, trying to map the fields but I get an error
>> > ??
>> >
>> > A
>> >
>>
>>
>
>