502100 MySQL queries for price update and extra info

Part one: I would like to update prices in a database (part of Joomla/Virtuemart). I uploaded the new prices to a table "jos_entra_prijs" (see [login to view URL]). The prices that need to be updated are in "jos_vm_product_price" (see [login to view URL]) The two tables can be linked via "jos_vm_product" (see [login to view URL]). jos_vm_product and jos_vm_product_price share product_id jos_vm_product and jos_entra_prijs share product_sku (same as artikelnr) For this operation I like to have the SQL queries. Part two: I like to extend the field product_s_desc (in jos_vm_product) with the text " ean: " and the content of field "ean-code" from jos_ean_prijs. I would like the SQL queries to accomplish this.