SELECT * FROM tb_product INNER JOIN tb_brand WHERE tb_product.brand_ID = tb_brand.brand_ID AND product_ID=''