UC知道急死我啦,救命啊,好多天了!!!!! 解决马上加分
来源：百度知道 编辑：UC知道 时间：2024/06/01 07:42:16
表user中有ID,Account等字段,
表Add_id有Id int not null,
User_id int,
Item_desc nvarchar(200),
Base_price money,
表有Item_price
Id int not null,
ItemId int,
UserId int,
Price money,
在这三个表中选择
select
Add_Item.Id as ItemId,Add_Item.Item_desc as 物品名称及描述,max(Item_price.Price) as 最高出价,
[User]. Name as 最高出价者, Add_Item.Base_price as 底价, User_1.Name as 货主
from [User] User_1 left outer join Item_price
inner join Add_Item on User_1.Id=Add_Item.[user_id ]
inner join [User] on [User].Id <> Item_price.UserId
group by Add_Item.Id,Add_Item.Item_desc,item_price.price,Add_Item.Base_price,[User].Name,User_1.Name
却无论如何达不到我要的效果,天啊,救命啊
就像个拍卖
按照我的理解，应该是这样，而且我已经建表验证过了
只不过你的需求表达得不清楚，而且各个表的字段名也命名得不规范，不一定能在你那运行起来
你这个说实话并不难，只不过有点复杂，分开来一步一步写，最后再合起来就可以了
select Add_Item.id as ItemId, Add_Item.Item_desc as 物品名称及描述, t.最高出价, t.最高出价者, Add_Item.Base_price as 底价, [user].[name] as 货主
from (select Item_price.ItemId as ItemId, [user].[name] as 最高出价者, Price as 最高出价
from Item_price, [user],
(select ItemId, max (Price) as MaxPrice
from Item_price
group by ItemId) as temp
where Item_price.ItemId = temp.ItemId and Item_price.Price = temp.MaxPrice and Item_price.userid = [user].id) as t
right outer join Add_Item on t.ItemId = Add_Item.id
inner join [user] on Add_Item.[user_id] = [user].id
from [User] User_1 left outer join Item_price
这里至少有个连接条件吧，from [User] User_1 left outer join Item_price on......?
呵呵！你提问了啊！
呵呵！
明天一定帮你搞定！
太专业了....