34,588
社区成员
发帖
与我相关
我的任务
分享
/**
*看看你的SQL连接语句在SQL查询分析器里执行的结果!是否超时!
*/
SELECT d.[AdType_Name],a.[ad_id],a.[ad_name],a.[ad_timeStart],a.[ad_timeEnd],b.[ci_name],c.[user_name],
CONVERT(INT,(SELECT SUM(pv_Browser) FROM [tb_PvAll_info] WHERE [pv_ad_id]=a.[ad_id])) AS [BROWSER_COUNT],
(SELECT SUM(pv_Click) FROM [tb_PvAll_info] WHERE [pv_ad_id]=a.[ad_id]) AS [CLICK_COUNT]
FROM [tb_ad_info] a
LEFT JOIN [tb_Company_info] b ON b.[ci_id]=a.[ad_CompanyID]
LEFT JOIN [tb_user_info] c ON c.[user_uid] = a.[ad_user_uID]
LEFT JOIN [tb_adtype_info] d ON d.[AdType_Code]=a.[ad_AdTypeCode] ORDER BY a.[ad_id] DESC
SELECT d.[AdType_Name],a.[ad_id],a.[ad_name],a.[ad_timeStart],a.[ad_timeEnd],b.[ci_name],c.[user_name],
CONVERT(INT,(SELECT SUM(pv_Browser) FROM [tb_PvAll_info] WHERE [pv_ad_id]=a.[ad_id])) AS [BROWSER_COUNT],
(SELECT SUM(pv_Click) FROM [tb_PvAll_info] WHERE [pv_ad_id]=a.[ad_id]) AS [CLICK_COUNT]
FROM [tb_ad_info] a
LEFT JOIN [tb_Company_info] b ON b.[ci_id]=a.[ad_CompanyID]
LEFT JOIN [tb_user_info] c ON c.[user_uid] = a.[ad_user_uID]
LEFT JOIN [tb_adtype_info] d ON d.[AdType_Code]=a.[ad_AdTypeCode] ORDER BY a.[ad_id] DESC