A
select isnull(Province_Quote.ProvinceName,'无分类') as ProvinceName,REPLACE ( substring (AppInfo.AppName,6,20), 'Soft' , '' ) as AppName,AppInfo.AppEName,QuoteProduct.orderid from QuoteProduct left join Quote on Quote.ID=QuoteProduct.QuoteID left join AppInfo on QuoteProduct.AppID=Appinfo.ID left join Province_Quote on QuoteProduct.ProvinceID=Province_Quote.id where quote.QuoteEName=参数A
B
select isnull(sum(web_download.downloadcounts),0) as DownLoadCounts from web_download,quote where quote.Quoteename=web_download.quoteename and quote.Quoteename=参数A将两句合为一句 参数都是一样的 并且可以根据DownLoadCounts进行排序应该怎么弄呢?
select isnull(Province_Quote.ProvinceName,'无分类') as ProvinceName,REPLACE ( substring (AppInfo.AppName,6,20), 'Soft' , '' ) as AppName,AppInfo.AppEName,QuoteProduct.orderid from QuoteProduct left join Quote on Quote.ID=QuoteProduct.QuoteID left join AppInfo on QuoteProduct.AppID=Appinfo.ID left join Province_Quote on QuoteProduct.ProvinceID=Province_Quote.id where quote.QuoteEName=参数A
B
select isnull(sum(web_download.downloadcounts),0) as DownLoadCounts from web_download,quote where quote.Quoteename=web_download.quoteename and quote.Quoteename=参数A将两句合为一句 参数都是一样的 并且可以根据DownLoadCounts进行排序应该怎么弄呢?
就是想把第二句得到的那个DownLoadCounts 合到第一句中,我要在第一句中根据这个DownLoadCounts来进行排序呢