Anonymous

SELECT 	Asset_ImageSizes.id, 	Asset_ImageSizes.imagename, 	Asset_ImageSizes.imagewidth, 	Asset_ImageSizes.imageheight, 	Asset_ProductImages.itemnmbr, 	Asset_ProductImages.imagename, 	Expr4 = 		CASE 		WHEN imageType IS NULL THEN 1 		WHEN itemnmbr = 'PCI1802' THEN 1 		ELSE 0 		END 	FROM Asset_ImageSizes LEFT JOIN 		Asset_ProductImages ON Asset_ImageSizes.id = Asset_ProductImages.imageType 	WHERE CASE 		WHEN imageType IS NULL THEN 1 		WHEN itemnmbr = 'PCI1802' THEN 1 		ELSE 0 	END = 1