CREATE VIEW dbo.kds_com7
AS
SELECT *,
(SELECT KeFuID
FROM PH_Company_KeFu
WHERE comid = a.comid) AS KeFuID,
(SELECT kdslevel
FROM PH_Company_KeFu
WHERE comid = a.comid) AS kdslevel,
(SELECT COUNT(*)
FROM ph_company_vipclick
WHERE comid = a.comid AND [year] = year(getdate()) AND
[month] = month(getdate())) AS jlsizeb,liulanliang as lll
FROM dbo.PH_Company_Base a
具体什么意思,a代表什么啊。执行出来结果什么
(SELECT KeFuID FROM PH_Company_KeFu WHERE comid = a.comid) AS KeFuID,
(SELECT kdslevel FROM PH_Company_KeFu WHERE comid = a.comid) AS kdslevel,
(SELECT COUNT(*) FROM ph_company_vipclick WHERE comid = a.comid AND [year] = year(getdate()) AND [month] = month(getdate())) AS jlsizeb,
liulanliang as lll
FROM dbo.PH_Company_Base a这样看的清楚。a 是别名
这点
a.comid =dbo.PH_Company_Base.comid