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