USE [db]
GO
/****** 对象:  View [dbo].[dindanspview3]    脚本日期: 06/07/2014 10:04:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER VIEW [dbo].[dindanspview3] 
AS 	SELECT     
dbo.dindan.id, 
dbo.dindan.name1, 
dbo.dindan.name2, 
dbo.dindan.ren, 
dbo.dindan.taoxijiage, 
dbo.dindan.payed4, 
dbo.dindansp.name, 
dbo.dindansp.shuliang, 
dbo.dindan.time1 
FROM dbo.dindan INNER JOIN dbo.dindansp ON 
dbo.dindan.id = dbo.dindansp.id