SELECT ENCOK_MALZEME.MALZKODU, Max([ENCOK_MALZEME].[EnÇokMİKTAR]) AS EnÇokEnÇokMİKTAR, ENCOK_MALZEMEDEPOLU.DEPO FROM (SELECT Depomik_TBL.MALZKODU, (Max([Depomik_TBL].[MİKTAR])) AS EnÇokMİKTAR FROM Depomik_TBL GROUP BY Depomik_TBL.MALZKODU)  AS ENCOK_MALZEME INNER JOIN (SELECT Depomik_TBL.MALZKODU, Depomik_TBL.DEPO, (Max([Depomik_TBL].[MİKTAR])) AS EnÇokMİKTAR FROM Depomik_TBL GROUP BY Depomik_TBL.MALZKODU, Depomik_TBL.DEPO) AS ENCOK_MALZEMEDEPOLU ON (ENCOK_MALZEME.MALZKODU = ENCOK_MALZEMEDEPOLU.MALZKODU) AND (ENCOK_MALZEME.EnÇokMİKTAR = ENCOK_MALZEMEDEPOLU.EnÇokMİKTAR) GROUP BY ENCOK_MALZEME.MALZKODU, ENCOK_MALZEMEDEPOLU.DEPO;

SELECT ENCOK_MALZEME.MALZKODU, Max([ENCOK_MALZEME].[EnCokMiktar]) AS EnCokMiktar, ENCOK_MALZEMEDEPOLU.DEPO FROM (SELECT Depomik_TBL.MALZKODU, (Max([Depomik_TBL].[MİKTAR])) AS EnCokMiktar FROM Depomik_TBL GROUP BY Depomik_TBL.MALZKODU)  AS ENCOK_MALZEME INNER JOIN (SELECT Depomik_TBL.MALZKODU, Depomik_TBL.DEPO, (Max([Depomik_TBL].[MİKTAR])) AS EnCokMiktar FROM Depomik_TBL GROUP BY Depomik_TBL.MALZKODU, Depomik_TBL.DEPO)  AS ENCOK_MALZEMEDEPOLU ON (ENCOK_MALZEME.EnCokMiktar = ENCOK_MALZEMEDEPOLU.EnCokMiktar) AND (ENCOK_MALZEME.MALZKODU = ENCOK_MALZEMEDEPOLU.MALZKODU) GROUP BY ENCOK_MALZEME.MALZKODU, ENCOK_MALZEMEDEPOLU.DEPO;