if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TabelaPrecos_V]') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view [dbo].[TabelaPrecos_V]
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

/****** Object:  View dbo.TabelaPrecos_V    Script Date: 10/05/2004 08:41:33 ******/
CREATE VIEW dbo.TabelaPrecos_V
AS
SELECT     TOP 100 PERCENT dbo.PRODUTOS.ProdNome, dbo.PROD_PRECOS.ProdPrecPreco, dbo.PROD_PRECOS.ProdID, dbo.PROD_PRECOS.TabelaID, 
                      dbo.PROD_PRECOS.ProdPrecID, dbo.TAB_PRECOS.FilialID
FROM         dbo.PRODUTOS INNER JOIN
                      dbo.PROD_PRECOS ON dbo.PRODUTOS.ProdID = dbo.PROD_PRECOS.ProdID INNER JOIN
                      dbo.TAB_PRECOS ON dbo.PROD_PRECOS.TabelaID = dbo.TAB_PRECOS.TabelaID
WHERE     (dbo.TAB_PRECOS.TabelaStatus = 0) AND (dbo.PRODUTOS.ProdStatus = 0)
ORDER BY dbo.PRODUTOS.ProdDesc

GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO