-- Find stocked parts that don't have an associated cost
SELECT
	cm.ProductCode,
	_VPW.MFG_SKU AS PIN,
	'VPW' AS VendorCode,
	_VPW.Parent,
	_VPW.Description,
	_VPW.Stock,
	_VPW.Cost,
	_VPW.Weight

FROM products._VPW
LEFT JOIN products.client_map cm ON cm.PIN = _VPW.MFG_SKU AND cm.Client = 'Volusion' AND cm.Parent IN('','FNLA')
WHERE _VPW.Cost = 0
AND _VPW.Stock > 0
;
