I know I am missing something

StevenYoung · Joined: 16 Mar 2010 Posts: 1

Ok, I am not new but I am missing something simple and I am not seeing it, dont we all do this at time?

If I run this query to a blank table it is fine, but to a table that has data and more fields I am getting an error

insert into 'retailwholesale'
select workingtable.retailprice from `workingtable`
WHERE workingtable.model = retailwholesale.model

Retail Price is only field I want to update to the 'retailwholesale' table. field name is retailprice in both tables. I know I have to define the field in the destination but using either insert into 'retailwholesale' (retailprice) or insert into 'retailwholesale.retailprice' also give errors. What am I missing?

Thank You
Steven

JemsRoker · Joined: 17 Mar 2010 Posts: 41 Location: Bangle of India

Try it from the beginning so you can find out the missing point.