评论会员:游客 时间:2012/02/06
。这应该给你的产品,他们卖日期价格codeprelang="sql"spanclass="code-keyword"SELECT/spanD.product_name,D.sell_date,(spanclass="code-keyword"SELECT/spanspanclass="code-keyword"TOP/spanspanclass="code-digit"1/spanM.pricespanclass="code-keyword"FROM/spanMaster_tableMspanclass="code-keyword"WHERE/spanM.product_name=D.Product_namespanclass="code-keyword"AND/spanM.receive_date>=D.sell_datespanclass="code-keyword"ORDER/spanspanclass="code-keyword"BY/spanM.receive_datespanclass="code-keyword"DESC/span)spanclass="code-keyword"FROM/spanDetail_tableD/pre/code
阿米尔Mahfoozi:
select top 1 rerceive_date , price from master_table order by receive_date desc
评论会员:armm1388 时间:2012/02/06
不,我想加入2表。 datail表主要记录
评论会员:Umairbaig 时间:2012/02/06
Select *
from Master_table m, Detail_table d
where m.product_name = d.product_name;
的此查询是为Oracle 9i