| 12345678910111213141516171819202122232425262728293031323334 |
- USE [db]
- GO
- /****** 对象: View [dbo].[photoprintview] 脚本日期: 05/23/2014 13:29:41 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- ALTER VIEW [dbo].[photoprintview] AS SELECT
- dbo.dindan.id, /* 订单号 */
- dbo.dindan.name1, /* 姓名1 */
- dbo.dindan.name2, /* 姓名2 */
- dbo.dindan.ren, /* 接单人:add by Jeff for ddf at 2014.08.02*/
- dbo.dindan.waiter4, /* 设计师:add by Jeff for ddf at 2014.08.02*/
- dbo.photoprint.name, /* 相片名称 */
- dbo.photoprint.count, /* 数量 */
- dbo.photoprint.status1, /* 发出状态 */
- dbo.photoprint.status2, /* 送回状态 */
- dbo.photoprint.statusOfReWork, /* 返工原因:add by Jeff for ddf at 2014.09.02 */
- dbo.photoprint.timeOfReWork, /* 返工日期:add by Jeff for ddf at 2014.09.02 */
- dbo.photoprint.time1, /* 发出日期 */
- dbo.photoprint.time2, /* 送回日期 */
- dbo.photoprint.area, /* 冲印面积 */
- dbo.dindan.status5, /**/
- dbo.dindan.urgent, /**/
- dbo.dindan.time5, /**/
- dbo.dindan.phone1, /**/
- dbo.dindan.phone2, /**/
- dbo.dindan.pinyin1, /**/
- dbo.dindan.pinyin2, /**/
- dbo.dindan.status3, /**/
- dbo.dindan.dindantype /**/
- FROM
- dbo.dindan LEFT OUTER JOIN dbo.photoprint
- ON dbo.dindan.id = dbo.photoprint.id
|
