Distinct语句用于mysql一次只返回一个唯一结果

Question

共有三张表：tbl住宿表--------------  -----------------------fldProductID     fldAccommodationName--------------  -----------------------tbl住宿表-------------  --------------------  ---------------------fldProductID   fldAccommodationText  fldAccommodationText1-------------  --------------------  ---------------------tbl住宿表------------  --------fldProductID  seo_url------------  --------具有不同的三表连接查询$sql = "SELECT         DISTINCT         tblAccommodation.fldProductID,        tblAccommodationText.fldAccommodationTextTitle,        seo_url,        tblAccommodation.fldAccommodationName    FROM tblAccommodation     LEFT JOIN tblAccommodationText         ON tblAccommodationText.fldProductID = tblAccommodation.fldProductId    LEFT JOIN tblProduct        ON tblProduct.fldProductID = tblAccommodation.fldProductID    WHERE        seo_url = 'yacht-4'";代码结果------------ ------------------------- ------- ------ --------------fldProductID fldAccommodationTextTitle seo_url fldAccommodationName------------ ------------------------- ------- ------ --------------6 海豚别墅 4 游艇 4 上舱6 Aqua Suite 游艇 - 4 Aqua Suite with Pool6 海豚别墅 4 游艇 4 上舱6 Aqua Suite 游艇 - 4 Aqua Suite with Pool为什么重复相同的值两次请帮帮我

Answer 1

您可以使用GROUP BY

SELECT tblAccommodation.fldProductID,fldAccommodationText1,tblAccommodationText.fldAccommodationTextTitle,seo_url,tblAccommodation.fldAccommodationName 

    FROM tblAccommodation 

        LEFT JOIN tblAccommodationText ON tblAccommodationText.fldProductID = tblAccommodation.fldProductID 

        LEFT JOIN tblProduct ON tblProduct.fldProductID = tblAccommodation.fldProductID 

        WHERE seo_url='yacht-4' 

    GROUP by tblAccommodationText.fldAccommodationTextTitle

Answer 2

代码首先工作我删除distinct并按功能在group后添加....

正确的查询是

$ SQL =“SELECT tblAccommodation.fldProductID，fldAccommodationText1，tblAccommodationText.fldAccommodationTextTitle，seo_url，tblAccommodation.fldAccommodationName FROM tblAccommodation LEFT JOIN tblAccommodationText ON tblAccommodationText.fldProductID = tblAccommodation.fldProductID LEFT JOIN tblProduct ON tblProduct.fldProductID = tblAccommodation.fldProductID其中seo_url ='yacht- 4' GROUP by tblAccommodationText.fldAccommodationTextTitle"