1234567891011121314151617181920 |
- 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
|