一道关于SQL子查询的问题

2008-01-10 11:52:42 93 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

Emuelec系统安装全流程：超详细版指南（从零开始）手把手带你完成emuelec系统的完整安装，从基础准备到系统配置一步不落，适合新手入门。深入解析emuelec在各类设备上的部署技巧，让复古游戏体验更流畅。阅读详情

select a.StockName,a.Modal,a.stockunit,a.instockid,b.MinPrice,
(select VenName from ZDB_Provider Where VenCode=(SELECT VenCode FROM STK_Order WHERE OrderID=(SELECT Top 1 OrderID from STK_OrderDtl where StockID=a.StockID and Price=b.MinPrice))) as 'MinProvider',
c.MaxPrice,
(select VenName from ZDB_Provider Where VenCode=(SELECT VenCode FROM STK_Order WHERE OrderID=(SELECT Top 1 OrderID from STK_OrderDtl where StockID=a.StockID and Price=c.MaxPrice))) as 'MaxProvider'
from zdb_instock a
left Join (select StockID,Min(Price) as MinPrice from STK_OrderDtl group by StockID) b on a.StockID=b.StockID
left Join (select StockID,Max(Price) as MaxPrice from STK_OrderDtl group by StockID) c on a.StockID=c.StockID
使用这个sql语句已经得到了一个结果集，现在想在这个结果集中继续得到指定供应商的信息,也就是MinProvider和MaxProvider是指定的供应商

...全文