#PropertiesResourceBundle for EURun2 Properties # Load Final Comparison Table 1=INSERT INTO CoffeeComp ( ID, Type, Pounds, Price ) SELECT ID, Type, Pounds, Price FROM CoffeeValT, CoffeeVend 2=UPDATE CoffeeComp SET Price = Price * .98 WHERE ID = 10 3=UPDATE CoffeeComp SET Price = Price * .97 WHERE ID = 20 4=UPDATE CoffeeComp SET Price = Price * 1.00 WHERE ID = 30 5=UPDATE CoffeeComp SET Price = Price * 1.23 WHERE ID = 40 6=UPDATE CoffeeComp SET Price = Price * 1.05 WHERE ID = 50 7=UPDATE CoffeeComp SET Price = Price * .92 WHERE ID = 60 8=UPDATE CoffeeComp SET Price = Price * .95 WHERE ID = 70 9=UPDATE CoffeeComp SET Price = Price * .90 WHERE ID = 80 10=UPDATE CoffeeComp SET Price = Price * 1.55 WHERE ID = 90 11=UPDATE CoffeeComp SET Price = Price * .99 WHERE ID = 100