dindanspview3.sql 920 B

1234567891011121314151617181920
  1. USE [db]
  2. GO
  3. /****** 对象: View [dbo].[dindanspview3] 脚本日期: 06/07/2014 10:04:13 ******/
  4. SET ANSI_NULLS ON
  5. GO
  6. SET QUOTED_IDENTIFIER ON
  7. GO
  8. ALTER VIEW [dbo].[dindanspview3]
  9. AS SELECT
  10. dbo.dindan.id,
  11. dbo.dindan.name1,
  12. dbo.dindan.name2,
  13. dbo.dindan.ren,
  14. dbo.dindan.taoxijiage,
  15. dbo.dindan.payed4,
  16. dbo.dindansp.name,
  17. dbo.dindansp.shuliang,
  18. dbo.dindan.time1
  19. FROM dbo.dindan INNER JOIN dbo.dindansp ON
  20. dbo.dindan.id = dbo.dindansp.id