SELECT oc_product.product_id, oc_product.price, oc_product_description.name ,oc_product.status FROM `oc_product` left join oc_product_description on oc_product.product_id=oc_product_description.product_id ORDER BY `oc_product`.`product_id` ASC