監(jiān)理公司管理系統(tǒng) | 工程企業(yè)管理系統(tǒng) | OA系統(tǒng) | ERP系統(tǒng) | 造價咨詢管理系統(tǒng) | 工程設(shè)計管理系統(tǒng) | 甲方項目管理系統(tǒng) | 簽約案例 | 客戶案例 | 在線試用
X 關(guān)閉

ALTER VIEW [dbo].[FZJView]

申請免費試用、咨詢電話：400-8352-114

    ALTER VIEW [dbo].[FZJView]
AS
SELECT     dbo.Clue.uClu_ID, dbo.Clue.dClu_CreateTime, dbo.Clue.cClu_Num, dbo.Clue.cClu_CName, dbo.Clue.iClu_Age, dbo.Clue.cClu_Phone, dbo.Grade.cGra_Name AS 年級,
                      dbo.ExtensionWorkers.cExtW_Name AS 推廣人員, dbo.Clue.cClu_State, dbo.Clue.cClu_KCGW, dbo.Channel.cCha_Name AS 渠道,
                      dbo.Clue.dClu_CreateTime AS Expr1
FROM         dbo.Clue LEFT OUTER JOIN
                      dbo.Channel ON dbo.Clue.uClu_ChaId = dbo.Channel.uCha_ID LEFT OUTER JOIN
                          (SELECT     uCha_CluId
                            FROM          dbo.Charge AS Charge_1
                            GROUP BY uCha_CluId) AS Charge ON dbo.Clue.uClu_ID = Charge.uCha_CluId LEFT OUTER JOIN
                      dbo.Grade ON dbo.Grade.uGra_ID = dbo.Clue.uClu_GraId LEFT OUTER JOIN
                      dbo.ExtensionWorkers ON dbo.ExtensionWorkers.uExtW_ID = dbo.Clue.uClu_ExtWId
WHERE     (Charge.uCha_CluId IS NULL) GO
USE [fjzxpx]
GO
發(fā)布：2007-03-30 10:23    編輯：泛普軟件 · xiaona    [打印此頁]    [關(guān)閉]