MS-SQL INNER JOIN 兩個Table重複值問題 _已解決

ms sql sql asp.net c#

小火車 2018-03-28 15:08:42 ‧ 10101 瀏覽

各位前輩好小弟目前在SQL上面INNER JOIN了兩個Table
搜尋出來會有重複值的出現，想請問有沒有語法或判斷式可以把重複值過濾掉呢??

SELECT DISTINCT Antibiotic_Patient_infor.Pa_infor_ID, Antibiotic_Patient_infor.P_ID, Antibiotic_PDF_info.P_ID, Antibiotic_PDF_info.PDF_CreTime, Antibiotic_PDF_info.PDF_Path, Antibiotic_Drog_info.Certification 
FROM Antibiotic_Patient_infor 
INNER JOIN Antibiotic_PDF_info 
ON Antibiotic_Patient_infor.P_ID = Antibiotic_PDF_info.P_ID 
INNER JOIN Antibiotic_Drog_info 
ON Antibiotic_Patient_infor.P_ID = Antibiotic_Drog_info.P_ID 
WHERE Antibiotic_Patient_infor.P_ID 
LIKE '32492'
OR  Antibiotic_Patient_infor.P_Name 
LIKE '32492'
ORDER BY Antibiotic_PDF_info.PDF_CreTime DESC;

登入發表討論

直播研討會

{{ item.channelVendor }} {{ item.webinarstarted }} |

直播中

1 個回答

暐翰

iT邦大師 1 級 ‧ 2018-03-28 15:12:46

最佳解答

select去掉Antibiotic_Drog_info.Certification

SELECT DISTINCT Antibiotic_Patient_infor.Pa_infor_ID, Antibiotic_Patient_infor.P_ID, Antibiotic_PDF_info.P_ID, Antibiotic_PDF_info.PDF_CreTime, Antibiotic_PDF_info.PDF_Path
FROM Antibiotic_Patient_infor 
INNER JOIN Antibiotic_PDF_info 
ON Antibiotic_Patient_infor.P_ID = Antibiotic_PDF_info.P_ID 
INNER JOIN Antibiotic_Drog_info 
ON Antibiotic_Patient_infor.P_ID = Antibiotic_Drog_info.P_ID 
WHERE Antibiotic_Patient_infor.P_ID 
LIKE '32492'
OR  Antibiotic_Patient_infor.P_Name 
LIKE '32492'
ORDER BY Antibiotic_PDF_info.PDF_CreTime DESC;