SELECT
jos_vm_product_price.product_price

FROM jos_vm_product,jos_vm_product_category_xref,jos_vm _product_price

WHERE
jos_vm_product_price.product_id=jos_vm_product_cat egory_xref.product_id
and jos_vm_product_category_xref.category_id=124

limit 15

UPDATE jos_vm_product_price set jos_vm_product_price.product_price
WHERE
jos_vm_product_price.product_id=jos_vm_product_cat egory_xref.product_id
and jos_vm_product_category_xref.category_id=124

UPDATE jos_vm_product_price, jos_vm_product_category_xref set jos_vm_product_price.product_price=10
WHERE
jos_vm_product_price.product_id=jos_vm_product_cat egory_xref.product_id
and jos_vm_product_category_xref.category_id=124