SELECT b.Path
+
b.StoreName AS imgpath
FROM Pdt_Photo AS a LEFT OUTER JOIN
CO_Picture AS b ON a.PictureId = b.PictureId
WHERE (a.PdtId = ' Pdt13730as4epP ' ) AND (a.IsMain = 1 )
FROM Pdt_Photo AS a LEFT OUTER JOIN
CO_Picture AS b ON a.PictureId = b.PictureId
WHERE (a.PdtId = ' Pdt13730as4epP ' ) AND (a.IsMain = 1 )