SQL - SerialMF vs SerialTx

/*Serial MF vs SerialTx*/
	
	SELECT TOP 100 
		/*SerialTx values:*/
		S.SNTxAccLink, S.SNTransType,S.SNWarehouseID
		/*SerialMF values:*/
		,M.CurrentAccLink, M.CurrentLoc
		,S.SNAuditNumber
		,* FROM SerialTX S 
		INNER JOIN (SELECT SNLink, MAX(SNTxCounter) as MaxTxID FROM SerialTX GROUP BY SNLink) S2 ON S.SNTxCounter = S2.MaxTxID AND S2.SNLink = S.SNLink
		LEFT JOIN SerialMF M ON S.SNLink = M.SerialCounter
	WHERE /*M.SNStockLink =164
		AND*/
		CASE WHEN M.CurrentLoc = 1 AND S.SNWarehouseID = M.CurrentAccLink THEN 1
			 WHEN M.CurrentLoc IN (3,2,6) AND (S.SNTxAccLink = M.CurrentAccLink OR S.SNWarehouseID = M.CurrentAccLink)THEN 1
			 ELSE 0 END = 0