跨数据库的视图【自己留着看】

None.gif SELECT      dbo.FEEDBACK_VIEW.PK_ID, dbo.FEEDBACK_VIEW.fld_channel_id, dbo.FEEDBACK_VIEW.fld_feedback_type, dbo.FEEDBACK_VIEW.fld_feedback, 
None.gif                      dbo.FEEDBACK_VIEW.fld_createtime, dbo.FEEDBACK_VIEW.fld_service1mail, dbo.FEEDBACK_VIEW.fld_service2mail, 
None.gif                      dbo.FEEDBACK_VIEW.fld_status, dbo.FEEDBACK_VIEW.fld_feedback_id, dbo.FEEDBACK_VIEW.fld_result, dbo.FEEDBACK_VIEW.fld_result_time, 
None.gif                      dbo.FEEDBACK_VIEW.fld_result_name, dbo.FEEDBACK_VIEW.fld_channel, dbo.FEEDBACK_VIEW.fld_channel_nickname, 
None.gif                      DB_OA.dbo.OA_USER.FLD_USERNAME, DB_OA.dbo.OA_USER.FLD_PHONE, DB_OA.dbo.OA_USER.FLD_EMAIL, 
None.gif                      DB_OA.dbo.OA_DEPT.FLD_DEPTNAME, dbo.FEEDBACK_VIEW.fld_staff_id
None.gif
FROM          dbo.FEEDBACK_VIEW  INNER   JOIN
None.gif                      DB_OA.dbo.OA_USER 
ON  dbo.FEEDBACK_VIEW.fld_staff_id  =  DB_OA.dbo.OA_USER.fld_UserId  INNER   JOIN
None.gif                      DB_OA.dbo.OA_DEPT 
ON  DB_OA.dbo.OA_USER.FLD_DEPTNO  =  DB_OA.dbo.OA_DEPT.FLD_DEPTNO

转载于:https://www.cnblogs.com/vagerent/archive/2007/07/04/805503.html

已标记关键词 清除标记
表情包
插入表情
评论将由博主筛选后显示,对所有人可见 | 还能输入1000个字符
©️2020 CSDN 皮肤主题: 编程工作室 设计师:CSDN官方博客 返回首页