Good Morning,
I am trying to use SQL to update a Product table with current prices. I thought the following would work to do that. For test purposes, I have only one product code (PCCode) in the PriceUpdate table. What happened when I ran the code was that all the Prices (P_Price1) were set to NULL. I guess this makes sense in that if a matching row in PriceUpdate is not found it would set it to NULL. UPDATE Products p1 SET p1.P_Price1 = (SELECT p2.PCPrice FROM PriceUpdate p2 WHERE ((p1.P_Part_Number = p2.PCCode) AND (p2.PCCode IS NOT NULL))); Is there a way to change this SQL to accomplish what I want to do 1) Or am I going to have to read the PriceUpdate table and use a loop in Witango to update the Product table 2) Or maybe a stored procedure to accomplish this Thanks in advance Steve Fogelson Internet Commerce Solutions ---------------------------------------- To unsubscribe from this list, please send an email to lists...@witango.com with "unsubscribe witango-talk" in the body.
