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