Anonymous

SELECT     dbo_Asset_ImageSizes.id, dbo_Asset_ImageSizes.imagename, dbo_Asset_ImageSizes.imagewidth, dbo_Asset_ImageSizes.imageheight,                       dbo_Asset_ProductImages.itemnmbr, Expr4 = 	CASE 	WHEN imageType IS NULL THEN 1	WHEN itemnmbr = 'PCI1802' THEN 1	ELSE 0	ENDFROM         dbo_Asset_ImageSizes LEFT JOIN                      dbo_Asset_ProductImages ON dbo_Asset_ImageSizes.id = dbo_Asset_ProductImages.imageTypeWHERE     CASE 		WHEN imageType IS NULL THEN 1 		WHEN itemnmbr = 'PCI1802' THEN 1 		ELSE 0	  END = 1;