CREATE VIEW dbo.DEPO_FIS_LISTESI
AS
SELECT DISTINCT LOGICALREF, DATE_, FICHENO,  CODE, DEFINITION_, GENEXP, (SELECT COUNT(*) FROM dbo.DEPO_FIS_MALZEME_LISTESI WHERE LOGICALREF=DFM.LOGICALREF AND ISONR='C') AS SAY, (SELECT COUNT(*) FROM dbo.DEPO_FIS_MALZEME_LISTESI WHERE LOGICALREF=DFM.LOGICALREF) AS TOPLAM FROM dbo.DEPO_FIS_MALZEME_LISTESI AS DFM WHERE ISONR='C'