| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849 |
- USE [db]
- GO
- /****** 对象: View [dbo].[takeview] 脚本日期: 06/23/2014 18:25:07 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- ALTER VIEW [dbo].[takeview]
- AS SELECT
- dbo.dindan.name1, /* 姓名1 */
- dbo.dindan.name2, /* 姓名2 */
- dbo.dindan.ren, /* 接单人 */
- dbo.dindan.taoxiname, /* 套系名称 */
- dbo.dindan.taoxijiage, /* 套系价格 */
- dbo.dindan.phone1, /* 电话1 */
- dbo.dindan.phone2, /* 电话2 */
- dbo.dindan.curno, /* 起始编号 */
- dbo.dindan.pinyin1, /* 拼音1 */
- dbo.dindan.pinyin2, /* 拼音2 */
- dbo.dindan.time3, /* */
- dbo.dindan.time5, /* */
- dbo.dindan.dindantype, /* 订单类型 */
- dbo.dindanjd.id, /* 订单号 */
- dbo.dindanjd.name, /* 景点名称 */
- dbo.dindanjd.date, /* 景点拍照时间 */
- dbo.dindanjd.time, /* #景点预约拍照时间# */
- dbo.dindanjd.waiter1, /* 摄影师 */
- dbo.dindanjd.waiter2, /* 化妆师 */
- dbo.dindanjd.status, /* 景点拍照状态 */
- dbo.dindanjd.waiter12, /* 摄影助理 */
- dbo.dindanjd.waiter22, /* 化妆助理 */
- dbo.dindanjd.bookingdate, /* #景点预约拍照日期# */
- dbo.dindanjd.dress, /* 礼服 */
- dbo.dindanjd.bz, /* 备注 */
- dbo.dindanjd.clerk, /* */
- dbo.dindanjd.inputtime, /* 录入时间 */
- dbo.dindanjd.branch, /* */
- dbo.dindan.status3, /* */
- dbo.dindan.payed4, /* */
- dbo.dindan.payed5, /* */
- dbo.dindan.money1, /* */
- dbo.client.birthday1, /* */
- dbo.client.check1, /* */
- dbo.client.sex /* */
- FROM dbo.dindan /* */
- INNER JOIN dbo.dindanjd
- ON dbo.dindan.id = dbo.dindanjd.id
- INNER JOIN dbo.client
- ON dbo.dindan.id = dbo.client.id
|
