Evolution - Serial vs WhseStk / _etblStockQtys

SELECT S.Code As StockCode, W.Code as WHCode
        ,Diff = WS.QtyOnHand - SN.SNQty
        ,WS.QtyOnHand, SN.SNQty
        --,WS.* 
		FROM _etblStockQtys WS
        LEFT JOIN (SELECT SNStockLink, CurrentAccLink, COUNT(*) as SNQty FROM SerialMF S WHERE S.CurrentLoc = 1 GROUP BY S.SNStockLink, S.CurrentAccLink) SN
            ON WS.StockID = SN.SNStockLink AND WS.WhseID = SN.CurrentAccLink
        LEFT JOIN StkItem S ON WS.StockID = S.StockLink
        LEFT JOIN WhseMst W ON WS.WhseID = W.WhseLink
        WHERE WS.QtyOnHand <> SN.SNQty

	/*SerialMF vs WhseStk*/
SELECT S.Code As StockCode, W.Code as WHCode
        ,Diff = WS.WHQtyOnHand - SN.SNQty
        ,WS.WHQtyOnHand, SN.SNQty
        --,WS.* 
		FROM WhseStk WS
        LEFT JOIN (SELECT SNStockLink, CurrentAccLink, COUNT(*) as SNQty FROM SerialMF S WHERE S.CurrentLoc = 1 GROUP BY S.SNStockLink, S.CurrentAccLink) SN
            ON WS.WHStockLink = SN.SNStockLink AND WS.WHWhseID = SN.CurrentAccLink
        LEFT JOIN StkItem S ON WS.WHStockLink = S.StockLink
        LEFT JOIN WhseMst W ON WS.WHWhseID = W.WhseLink
        WHERE WS.WHQtyOnHand <> SN.SNQty