USE [AGA]
GO

/****** Object:  View [dbo].[Qty_Jual]    Script Date: 03/05/2026 16:45:48 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE VIEW [dbo].[Qty_Jual]
AS
SELECT     dbo.Barang.Kode, ISNULL(SUM(dbo.JualDetail.Qty), 0) AS Jual
FROM         dbo.Barang LEFT OUTER JOIN
                      dbo.JualDetail ON dbo.Barang.Kode = dbo.JualDetail.KodeBrg
GROUP BY dbo.Barang.Kode

GO