Thread: Update Help
Hi,
Let say I have 2 Product table, both of them has columns ProductID and Price
What is the update command if I want to update all Prices of first table to be equal with Price in second table?
Please Help.
Yudie
On Tue, 2002-09-03 at 17:38, Yudie@axiontech.com wrote: > Let say I have 2 Product table, both of them has columns ProductID and Price > What is the update command if I want to update all Prices of first table to be equal with Price in second table? UPDATE table1 SET price = (SELECT price FROM table2 WHERE table1.product = table2.product); -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight, UK http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C ======================================== "And he said unto his disciples, Therefore I say unto you, Take no thoughtfor your life, what ye shall eat; neither for the body, what ye shall put on. For life is more than meat,and the body is more than clothing. Consider the ravens, for they neither sow nor reap; they have neither storehousenor barn; and yet God feeds them; how much better you are than the birds! Consider the lilies, how theygrow; they toil not, they spin not; and yet I say unto you, that Solomon in all his glory was not arrayedlike one of these. If then God so clothe the grass, which is to day in the field, and tomorrow is cast intothe oven; how much more will he clothe you, O ye of little faith? And seek not what ye shall eat, or whatye shall drink, neither be ye of doubtful mind. But rather seek ye the kingdom of God; and all these thingsshall be added unto you." Luke 12:22-24; 27-29; 31.
Yudie@axiontech.com writes: > Let say I have 2 Product table, both of them has columns ProductID and > Price What is the update command if I want to update all Prices of first > table to be equal with Price in second table? Possibly you mean something like this: UPDATE first_table SET price = (SELECT price FROM second_table WHERE second_table.productid = first_table.productid); Possibly the answer is also to redesign your schema to avoid redundant data. -- Peter Eisentraut peter_e@gmx.net