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

SELECT     dbo.FEEDBACK_VIEW.PK_ID, dbo.FEEDBACK_VIEW.fld_channel_id, dbo.FEEDBACK_VIEW.fld_feedback_type, dbo.FEEDBACK_VIEW.fld_feedback, 
                      dbo.FEEDBACK_VIEW.fld_createtime, dbo.FEEDBACK_VIEW.fld_service1mail, dbo.FEEDBACK_VIEW.fld_service2mail, 
                      dbo.FEEDBACK_VIEW.fld_status, dbo.FEEDBACK_VIEW.fld_feedback_id, dbo.FEEDBACK_VIEW.fld_result, dbo.FEEDBACK_VIEW.fld_result_time, 
                      dbo.FEEDBACK_VIEW.fld_result_name, dbo.FEEDBACK_VIEW.fld_channel, dbo.FEEDBACK_VIEW.fld_channel_nickname, 
                      DB_OA.dbo.OA_USER.FLD_USERNAME, DB_OA.dbo.OA_USER.FLD_PHONE, DB_OA.dbo.OA_USER.FLD_EMAIL, 
                      DB_OA.dbo.OA_DEPT.FLD_DEPTNAME, dbo.FEEDBACK_VIEW.fld_staff_id
FROM         dbo.FEEDBACK_VIEW INNER JOIN
                      DB_OA.dbo.OA_USER 
ON dbo.FEEDBACK_VIEW.fld_staff_id = DB_OA.dbo.OA_USER.fld_UserId INNER JOIN
                      DB_OA.dbo.OA_DEPT 
ON DB_OA.dbo.OA_USER.FLD_DEPTNO = DB_OA.dbo.OA_DEPT.FLD_DEPTNO
posted on 2007-07-04 12:32  上午的绝缘杯  阅读(1154)  评论(0编辑  收藏  举报