This example may be help full for you.
UPDATE xcart_products INNER JOIN xcart_extra_field_valuesON xcart_extra_field_values.productid = xcart_products.productidSET xcart_products.forsale = 'N' WHERE xcart_extra_field_values.value = 'article' and xcart_extra_field_values.fieldid=1...