You need a
left join[
^] from product to picture.
SELECT Product_tbl.*,Picture_tbl.Image
FROM Product_tbl
LEFT JOIN Picture_tbl
ON Picture_tbl.ProductID = Product_tbl.ProductID AND Picture_tbl.Status = 'PImage Front'
where Product_tbl.UserName='muneerhussan' and Product_tbl.PageID=15 order by Upload_DateTime DESC
This will pull all products, even those where there is no image. In that case the image column will be null.