具有内部联接的MYSQL查询结果 - MYSQL query result with inner join

MYSQL query result with inner join

本文关键字：MYSQL 查询结果内部 | 更新日期: 2024-04-30

下面的查询正在工作，但它多次给我相同的数据。。。。建议我苦读这个

"SELECT 
     cp.projectID,cp.projectName,cp.clientID,
     pv.vendorID,
     cv.vendorName,
     c.clientName,
     vp.productName,
     pp.sku
FROM clientProjects AS cp 
    INNER JOIN clients AS c ON c.clientID = cp.clientID
    INNER JOIN projectVendors AS pv ON cp.projectID = pv.projectID
    INNER JOIN clientVendors AS cv ON cv.vendorID = pv.vendorID
    INNER JOIN projectProducts AS pp ON cp.projectID = pp.projectID 
    INNER JOIN projectMaintenance AS pm ON cp.projectID = pm.projectID
    INNER JOIN vendorProducts AS vp ON pp.sku = vp.sku
    INNER JOIN projectFiles AS pf ON cp.projectID = pf.projectID
WHERE cp.projectName LIKE '".$projectName."' OR c.clientName LIKE '".$projectName."' OR pp.sku LIKE '".$projectName."' OR pm.sku LIKE '".$projectName."' "

尝试DISTINCT:

SELECT DISTINCT cp.projectID,
                cp.projectName,
                cp.clientID, 
                pv.vendorID, 
                cv.vendorName, 
                c.clientName, 
                vp.productName, 
                pp.sku
FROM clientProjects AS cp 
INNER JOIN clients AS c ON c.clientID = cp.clientID
INNER JOIN projectVendors AS pv ON cp.projectID = pv.projectID
INNER JOIN clientVendors AS cv ON cv.vendorID = pv.vendorID
INNER JOIN projectProducts AS pp ON cp.projectID = pp.projectID 
INNER JOIN projectMaintenance AS pm ON cp.projectID = pm.projectID
INNER JOIN vendorProducts AS vp ON pp.sku = vp.sku
INNER JOIN projectFiles AS pf ON cp.projectID = pf.projectID
WHERE cp.projectName LIKE '".$projectName."' OR 
      c.clientName LIKE '".$projectName."' OR 
      pp.sku LIKE '".$projectName."' OR 
      pm.sku LIKE '".$projectName."' "