MySQL Forums
Forum List  »  Newbie

How to get sku and their tax_class_id is not equal to 'vat standard'
Posted by: subs s
Date: May 06, 2014 09:44AM

I want to get sku and their tax_class_id is not equal to 'vat standard'. I use following code and got sku and tax_class_id (it's showing 5). But I got another table called 'tax_class' which has a class_id and 5 means 'VAT Standard'. I want got get sku which does not have 5 as tax_class_id. How can i join tax_class with this code as it does not have entity_id, attribute_id or so on? Can anyone help?

SELECT e.sku, eav.value AS vat
FROM catalog_product_entity e
JOIN catalog_product_entity_int eav
ON e.entity_id = eav.entity_id
JOIN eav_attribute ea
ON eav.attribute_id = ea.attribute_id
WHERE ea.attribute_code = 'tax_class_id'

Options: ReplyQuote


Subject
Written By
Posted
How to get sku and their tax_class_id is not equal to 'vat standard'
May 06, 2014 09:44AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.