lyfz_repos/经典版源码/document/数据库表脚本/memberview-会员充值记录视图.sql

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