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 [url removed, login to view]). The prices that need to be updated are in "jos_vm_product_price" (see [url removed, login to view]) The two tables can be linked via "jos_vm_product" (see [url removed, login to view]).
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.
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.