你好,我想选择每个与状态=' won‘的出价id相关联的拍卖id,以及每个状态’过期‘的拍卖id,因为我的语句中的两个分隔列可以帮助您,第一列将被调用won,第二列将过期。
SELECT
Auction.AuctionID,
DATENAME(mm, BID.Date) AS Month
FROM
BID INNER JOIN Auction ON BID.AuctionID = Auction.AuctionID
WHERE
BID.Status = 'Won'
ORDER BY Month
预期结