GO /****** Object: View [dbo].[VT_CPTES_COMISION_FAMCB] Script Date: 11/27/2017 14:13:05 ******/ IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[VT_CPTES_COMISION_FAMCB]')) DROP VIEW [dbo].[VT_CPTES_COMISION_FAMCB] GO GO /****** Object: View [dbo].[VT_CPTES_COMISION_FAMCB] Script Date: 11/27/2017 14:13:05 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[VT_CPTES_COMISION_FAMCB] AS SELECT dbo.V_MV_Cpte.TC, dbo.V_MV_Cpte.IDCOMPROBANTE, dbo.V_MV_Cpte.IDCOMPLEMENTO, dbo.V_MV_Cpte.FECHA, dbo.V_MV_Cpte.CUENTA, dbo.V_MV_Cpte.IdVendedor, dbo.V_MV_CpteInsumos.IDARTICULO, dbo.V_MV_CpteInsumos.DESCRIPCION, dbo.V_MV_CpteInsumos.CANTIDAD, dbo.V_MV_CpteInsumos.TOTAL, dbo.V_MA_ARTICULOS.IdFamilia, dbo.V_TA_FAMILIAS.Descripcion AS DescFam, dbo.V_MV_Cpte.SUCURSAL, dbo.V_MV_Cpte.NUMERO, dbo.V_MV_Cpte.LETRA FROM dbo.V_MA_ARTICULOS LEFT OUTER JOIN dbo.V_TA_FAMILIAS ON dbo.V_MA_ARTICULOS.IdFamilia = dbo.V_TA_FAMILIAS.IdFamilia RIGHT OUTER JOIN dbo.V_MV_CpteInsumos ON dbo.V_MA_ARTICULOS.IDARTICULO = dbo.V_MV_CpteInsumos.IDARTICULO RIGHT OUTER JOIN dbo.V_MV_Cpte ON dbo.V_MV_CpteInsumos.TC = dbo.V_MV_Cpte.TC AND dbo.V_MV_CpteInsumos.IDCOMPROBANTE = dbo.V_MV_Cpte.IDCOMPROBANTE AND dbo.V_MV_CpteInsumos.IDCOMPLEMENTO = dbo.V_MV_Cpte.IDCOMPLEMENTO GO