Select A.Vits_name,C.Specialties_name
From vits A
Inner Join vet_specialties B
On A.Vits_ID=B.Vit_ID
Inner Join specialties C
On B.Specialty_ID=C.Specialties_ID這樣不可以嗎??
From vits A
Inner Join vet_specialties B
On A.Vits_ID=B.Vit_ID
Inner Join specialties C
On B.Specialty_ID=C.Specialties_ID這樣不可以嗎??
From vits A
Inner Join vet_specialties B
On A.Vits_ID=B.Vit_ID
Inner Join specialties C
On B.Specialty_ID=C.Specialties_ID
Where A.Vits_ID=條件或者Select A.Vits_name,C.Specialties_name
From vits A
Inner Join vet_specialties B
On A.Vits_ID=B.Vit_ID
Inner Join specialties C
On B.Specialty_ID=C.Specialties_ID
Where A.Vits_name=條件
From vits A
left Join vet_specialties B
On A.Vits_ID=B.Vit_ID
left Join specialties C
On B.Specialty_ID=C.Specialties_ID
Where A.Vits_name=條件
用left join可以查出没有专业的兽医
这个vet_specialties_ID 是什么?
---------------------
這個,我還要問你呢。我的語句裡沒有這麼個東西啊。
这个vet_specialties
是什么?
我现在还是个学生 还很嫩 呵呵 谢谢
from vits
full outer join vet_specialties
on vits.Vits_ID = vet_specialties.Vits_ID
full outer join specialties
on specialties.Specialty_ID = vet_specialties.Specialty_ID
where vits.Vits_name = ??