Skip to content

Magento 2 : Create a JOIN

I am trying to fetch manufacturer attribute value using SKU. Here is my query which works fine. SELECT nametable.value, catalog_product_entity.sku FROM catalog_product_entity_varchar AS nametable LEFT JOIN catalog_product_entity ON nametable.entity_id = catalog_product_entity.entity_id WHERE nametable.attribute_id = (SELECT attribute_id FROM eav_attribute WHERE entity_type_id… Read More »Magento 2 : Create a JOIN