I have two tableS: N1 and B1. I can update B1 within whole database of N1. The problem is N1's field6 as name as 2013 sales. This name will be change in future. How can I set equal to two tables' value without point to name, such as column6?
UPDATE N1 INNER JOIN B1 ON N1.ID=B1.ID SET B1.[2013 sale] = N1.[2013 sale]
Can I change "2013 sale " to field6 or column6?
Thank you
UPDATE N1 INNER JOIN B1 ON N1.ID=B1.ID SET B1.[2013 sale] = N1.[2013 sale]
Can I change "2013 sale " to field6 or column6?
Thank you