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 Pool

6 海豚别墅 4 游艇 4 上舱

6 Aqua Suite 游艇 - 4 Aqua Suite with Pool

为什么重复相同的值两次请帮帮我

Answer 1

您可以使用GROUP BYSELECT 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"