| 1234567891011121314151617181920 |
- USE [db]
- GO
- /****** 对象: View [dbo].[memberview] 脚本日期: 06/28/2014 10:59:17 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- ALTER VIEW [dbo].[memberview] AS SELECT
- dbo.membermanage.name, /* 会员姓名 */
- dbo.memberreg3.memberno, /* 充值的会员卡号 */
- dbo.memberreg3.money, /* 充值金额 */
- dbo.memberreg3.date, /* 充值日期 */
- dbo.memberreg3.clerk, /* 经手人 */
- dbo.memberreg3.id, /* 充值记录id */
- dbo.memberreg3.financecheck, /* 财务审核 */
- dbo.memberreg3.moneytype, /* 支付方式 */
- dbo.memberreg3.time /* 充值时间 */
- FROM dbo.memberreg3 INNER JOIN
- dbo.membermanage ON
- dbo.memberreg3.memberno = dbo.membermanage.memberno
|
