WITH cte AS ( SELECT A.EANCode, A.Aantal, S.[Segment] FROM tbl_StockYear AS A JOIN tbl_Stamdata AS S ON A.EANCode = S.EANCode WHERE A.StockYear = '2024' UNION ALL SELECT B.EANCode, B.Aantal, S.[Segment] FROM tbl_Inkoop AS B JOIN tbl_Stamdata AS S ON B.EANCode = S....