sql²éѯ - MS-SQL Server / ÒÉÄÑÎÊÌâ

Óиö±í ÊôÐÔÓÐÔ±¹¤µÄ±àºÅID Ô±¹¤µÄÃû×Öname;
ÁíÍâÒ»¸ö±íÀïÃæÓв¿ÃŵıàºÅtID ²¿ÃŵÄÃû×Ötname,²¿Ãž­ÀíµÄ±àºÅMID,×ܼàµÄÃû×ÖDId;
ÏÖÔÚҪн¨Ò»¸öview ÀïÃæÓв¿ÃŵıàºÅ,²¿ÃŵÄÃû×Ö ²¿Ãž­ÀíµÄÃû×Ö ºÍ×ܼàµÄÃû×Ö
ÏÖÓеÄsqlÓï¾ä:
select tba.tID,tba.tname,tba.MName,tbb.DName
from
(select b.tID,b.tname,a.name as MName
from a,b
where a.ID = b.MID) as tba,
(select b.tID,b.tname,a.name as DName
from a,b
where a.ID = b.DId) as tbb
where tba.tID = tbb.tID
µ«·¢ÏÖЧÂʲ»Ì«¸ß,ÇëÎÊÓÐʲô¸ßЧµÄ·½·¨Âð

---

SFÊÇÎÒµÄ

---

MS²»ÐèҪǶÌ×

---

µÈ´ý¸ßÊÖ½â´ð °ï¶¥£¡

---

SQL code:
select b1.tid.b1.tname,b2.mname,b2.dname
from a a
left join b b1 on a.id=b.mid
left join b b2 on a.id=b.did
where b1.tid=b2.tid

---

SQL code:
--òËÆÕâÑù¾Í¿ÉÒÔ²é³öÀ´ÁË
select
tid,tname,mid,did
from
tb

---

SQL code:
Òª²»È»ÊÇÕâÑù?
select
b1.tid.b1.tname,b2.mname,b2.dname
from
tb a
left join
tb b1 on a.id=b.mid
left join
tb b2 on a.id=b.did
where
b1.tid=b2.tid

---

SQL code

---

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.