请问,我下面这句SQL语句,为什么会有个字段的值或重复呢?
Select
f.BuyUserID,
f.sellUserID,
SellUserName=(Select UserName From SouBao_UserDealing Where UserID=F.SellUserID),
SellGMonery=(Select GMonery From SouBao_UserDealing Where UserID=F.SellUserID),
SellFreezeGMonery=(Select FreezeGMonery From SouBao_UserDealing Where UserID=F.SellUserID),
BuyUserName=(Select UserName From SouBao_UserDealing Where UserID=F.BuyUserID),
BuyGMonery=(Select GMonery From SouBao_UserDealing Where UserID=F.BuyUserID),
BuyFreezeGMonery=(Select FreezeGMonery From SouBao_UserDealing Where UserID=F.BuyUserID)
From
SouBao_Sell T
Inner Join SouBao_SellOrderForm F
ON T.DealingID=F.DealingID
Where
F.FormID='32'
上面的结果当中,SellUserName与BuyUserName的结果都是相同的,结果都是为admin。但实际上真实的数据是二个不相同的字段值,SellUserName=admin,BuyUserName=cnzc。我的SQL语句有问题吗?