[SQL ] 請問這兩個語法結果一樣嗎?

作者: evilove (願意感動就是一種享受)   2016-06-17 11:12:59
資料庫名稱:MySQL
內容/問題描述:您好我是初學者,想知道下面兩個語法的結果是一樣的嗎?
謝謝!
SELECT COUNT(DISTINCT pid) AS Hispanic
FROM (SELECT patients.pid, patients.ethnicity, ethnicity.Name, ethnicity.Code
FROM ethnicity
INNER JOIN patients
ON patients.ethnicity=ethnicity.Code)
WHERE Name='Hispanic or Latino';
SELECT COUNT(DISTINCT patients.pid) AS Hispanic
FROM ethnicity, patients
WHERE patients.ethnicity=ethnicity.Code
AND ethnicity.Name='Hispanic or Latino';
作者: Ammenze (藍天白雲)   2016-06-17 12:19:00
應該是一樣的
作者: evilove (願意感動就是一種享受)   2016-06-17 23:16:00
謝謝您~

Links booklink

Contact Us: admin [ a t ] ucptt.com