共有三張表：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為什么重復相同的值兩次請幫幫我
1 回答
慕蓋茨4494581
TA貢獻1850條經驗 獲得超11個贊
您可以使用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
一只斗牛犬
TA貢獻1784條經驗 獲得超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"
- 1 回答
- 0 關注
- 198 瀏覽
添加回答
舉報
0/150
提交
取消