MySql|选择所有带有内连接的内容，没有重复的值

Question

这是我的查询:

SELECT * FROM Products as pr
INNER JOIN Customers as ct
ON ct.supplierUUID = pr.supplierUUID
LEFT JOIN FavoriteProducts as fp
ON ct.customerUUID = fp.favoriteCustomerUUID
WHERE ct.customerUUID = '101049356085569448728'

我得到以下结果:

+------------+-------------+--------+------------------+-------------+ ... and so
|productsID  |productName  | price  |favoriteProductID |customerID   | 
+------------+-------------+--------+------------------+-------------+
| 1          |  apple      | 3      | 1                | 123         |
+------------+-------------+--------+------------------+-------------+
| 1          |  apple      | 3      | 1                | 123         | 
+------------+-------------+--------+------------------+-------------+
| 2          | computer    | 10     | 2                | 123         |
+------------+-------------+--------+------------------+-------------+ 
| 2          | computer    | 10     | 2                | 123         |
+------------+-------------+--------+------------------+-------------+

如何选择所有内容而不重复？

我希望结果是这样的:

+------------+-------------+--------+------------------+-------------+ ... and so
|productsID  |productName  | price  |favoriteProductID |customerID   | 
+------------+-------------+--------+------------------+-------------+
| 1          |  apple      | 3      | 1                | 123         |
+------------+-------------+--------+------------------+-------------+
| 2          | computer    | 10     | 2                | 123         |
+------------+-------------+--------+------------------+-------------+

我尝试添加 GROUP BY 但出现错误

SELECT * FROM Products as pr
Inner JOIN Customers as ct
ON ct.supplierUUID = pr.supplierUUID
LEFT JOIN FavoriteProducts as fp
ON ct.customerUUID = fp.favoriteCustomerUUID
where ct.customerUUID = '101049356085569448728'
**GROUP BY pr.productID**;

谢谢!!

Answer 1

您可以使用 DISTINCT

SELECT DISTINCT productsID, productName, price, favoriteProductID, customerID   
FROM Products as pr
INNER JOIN Customers as ct ON ct.supplierUUID = pr.supplierUUID
LEFT JOIN FavoriteProducts as fp ON ct.customerUUID = fp.favoriteCustomerUUID
WHERE ct.customerUUID = '101049356085569448728'