This may be very simple, but the solution eludes me.. I have two tables Products and NewProducts, The Products table contains a list of all the current product line and prices Products.ProdCode, Products.Price (amongst other details not relevent here). NewProducts contains a list of changes to be made to the database, ie New Product lines, changes of prices to existing lines. (NewProducts.ProdCode, NewProducts.Price).
How can I update existing records in Products if ProdCode are equal in both tables, and if ProdCode exists in NewProducts but Not in Products, insert that records? We are using MySQL Version 3.23.54a Thanks Michael Watson MBW Computing [EMAIL PROTECTED] Tel: 03 9782-0427 Fax: 03 9782-0657 Mob: 0425 788-185 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
