select * from mk_quote
where ProductId=1 And pDate = (Select Max(pDate) from mk_quote where ProductId=1)
select distinct productId from mk_quote where saler=1
怎么能将这两句合成一句?
第一局中的 prodcutid 从 第二局中取值
...全文
574打赏收藏
关于报价的问题 标题说不清 不是一般的问题! :)
select * from mk_quote where ProductId=1 And pDate = (Select Max(pDate) from mk_quote where ProductId=1) select distinct productId from mk_quote where saler=1 怎么能将这两句合成一句? 第一局中的 prodcutid 从 第二局中取值
select * from mk_quote
where ProductId in (select distinct productId from mk_quote where saler=1) And pDate = (Select Max(pDate) from mk_quote where ProductId=1)
select * from mk_quote
where ProductId in (select distinct productId from mk_quote where saler=1) And pDate = (Select Max(pDate) from mk_quote where ProductId in (select distinct productId from mk_quote where saler=1))
select * from mk_quote as A
where ProductId in (select distinct productId from mk_quote where saler=1) And pDate = (Select Max(pDate) from mk_quote where ProductId=A.ProductId)