ÇóÒ»¸öSQLÓï¾ä - MS-SQL Server / »ù´¡Àà

ÏÖÓÐÈýÕűí
±íA£ºÑ§ÉúID¡¢Ñ§ÉúÃû
±íB£º¿Î³ÌID¡¢¿Î³ÌÃû
±íC£ºÑ§ÉúID¡¢¿Î³ÌID¡¢³É¼¨

Èç¹ûÏëÊä³öÏÂÁÐÖµ:
²Î¼ÓÁËijÃſγ̵ÄËùÓÐѧÉúµÄѧÉúÃû¡¢¿Î³ÌÃû¡¢³É¼¨

SQLÓï¾ä¸ÃÔõôд£¿ÓÃÒ»¾äSQLÓï¾äÄÜʵÏÖÂ𣿠

---

SQL code:
select a.ѧÉúÃû,b.¿Î³ÌÃû,c.³É¼¨
from a ,b,c
where a.ѧÉúID = c.ѧÉúID and c.¿Î³ÌID = b.¿Î³ÌID and b.¿Î³ÌÃû = 'ijÃſγÌ'

---

SQL code:
select
a.ѧÉúÃû,b.¿Î³ÌÃû,c.³É¼¨
from
a,b,c
where
a.ѧÉúID=c.ѧÉúID
and
b.¿Î³ÌID=c.¿Î³ÌID
and
b.¿Î³ÌID=xx

---

SQL code:
select
a.ѧÉúÃû,b.¿Î³ÌÃû,c.³É¼¨
from
a,b,c
where
a.ѧÉúID=c.ѧÉúID
and
b.¿Î³ÌID=c.¿Î³ÌID
and
b.¿Î³ÌÃû='xx'

---

SQL code:
select a,ѧÉúÃû,b.¿Î³ÌÃû,c.³É¼¨ from a join c on a.ѧÉúID=c.ѧÉúID join b on c.¿Î³ÌID=b.¿Î³ÌID where b.¿Î³ÌÃû='ijÃſγÌÃû'

---

SQL code:
select a.ѧÉúÃû,b.¿Î³ÌÃû,c.³É¼¨ from a,b,c
where a.ѧÉúID=c.ѧÉúID and b.¿Î³ÌI