1.
SELECT DISTINCT t2.Selldate, t1.IDBuy AS Expr1, t1.Buyname
2.
FROM (UserBuy t1 INNER JOIN
3.
(SELECT IDauto, IDSell, Selldate, Sellmoney, Sellmoney2, Selltotalmoney, IDbuy
4.
FROM UserSellitem
5.
WHERE (Selldate BETWEEN ? AND ?)) t2 ON t1.IDBuy = t2.IDbuy)