Select tblproduct.ProductID as ProductID , tblproduct.ProductNameEN as ProductName , tblproduct.ProductImage as ProductImage , tblcategory.CatNameEn as ParentCat from tblcategory,tblproduct WHERE tblcategory.CatID=tblproduct.ProductCat AND tblproduct.ProductCat=42 ORDER BY tblproduct.ProductID DESC