create procedure getInfo
as
select [站点类型]=B.Type_Name,
[站点名称]=A.Site_Name,
[主行业名称]=(select channel_Name from u_Channel_Info where ID=C.Main_Channel_ID and Site_ID=A.ID),
[子行业名称]=select top 1 channel_Name from u_Channel_Info where ID<>C.Main_Channel_ID and Site_ID=A.ID),
[页名称]=D.Page_name,
[广告类型]=F.Type_Name,
[广告名称]=E.AD_Description
from [u_Site_Info] A
join [u_Site_Type] B on A.SiteTypeID=B.ID
join [u_Channel_Info] C on A.ID=C.Site_ID
join [u_Page_Info] D on D.channel_ID=C.ID
join [u_AD_Info] E on E.Page_ID=D.ID
join [u_AD_Type] F on F.ID=E.AD_Type_IDgo
as
select [站点类型]=B.Type_Name,
[站点名称]=A.Site_Name,
[主行业名称]=(select channel_Name from u_Channel_Info where ID=C.Main_Channel_ID and Site_ID=A.ID),
[子行业名称]=select top 1 channel_Name from u_Channel_Info where ID<>C.Main_Channel_ID and Site_ID=A.ID),
[页名称]=D.Page_name,
[广告类型]=F.Type_Name,
[广告名称]=E.AD_Description
from [u_Site_Info] A
join [u_Site_Type] B on A.SiteTypeID=B.ID
join [u_Channel_Info] C on A.ID=C.Site_ID
join [u_Page_Info] D on D.channel_ID=C.ID
join [u_AD_Info] E on E.Page_ID=D.ID
join [u_AD_Type] F on F.ID=E.AD_Type_IDgo
as
select [站点类型]=B.Type_Name,
[站点名称]=A.Site_Name,
[主行业名称]=(select channel_Name from u_Channel_Info where ID=C.Main_Channel_ID and Site_ID=A.ID),
[子行业名称]=(select top 1 channel_Name from u_Channel_Info where ID<>C.Main_Channel_ID and Site_ID=A.ID),
[页名称]=D.Page_name,
[广告类型]=F.Type_Name,
[广告名称]=E.AD_Description
from [u_Site_Info] A
join [u_Site_Type] B on A.SiteTypeID=B.ID
join [u_Channel_Info] C on A.ID=C.Site_ID
join [u_Page_Info] D on D.channel_ID=C.ID
join [u_AD_Info] E on E.Page_ID=D.ID
join [u_AD_Type] F on F.ID=E.AD_Type_IDgo
As
Select
B.[Type_Name] As 站点类型,
A.SiteName As 站点名称,
C.Channel_Name As 主行业名称,
D.Channel_Name As 子行业名称,
E.Page_Name As 页名称,
G.[Type_Name] As 广告类型,
F.SiteName As 广告名称
from u_Site_Info A
Left Join u_Site_Type B On A.SiteTypeID=B.ID
Left Join u_Channel_Info C On A.ID=C.Site_ID
Left Join u_Channel_Info D On C.id=D.Main_Channel_ID
Left Join u_Page_Info E On C.id=E.Channel_ID
Left Join u_ad_info F On E.id=F.page_id
Left Join u_ad_type G On F.ad_type_id=G.id
Go
EXEC List
1 1 1 1 1
2 2 2 2 2 table2:field1 field2 field4 field5 field6
3 3 3 3 3
4 4 4 4 4 合并之后的表:field1 field2 field3 field4 field5 field6
1 1 1 1 1 Null
2 2 2 2 2 Null
3 3 Null 3 3 3
4 4 Null 4 4 4