oracle ²éѯ£¬ÒÔ¼°Ð§ÂÊ¿¼ÂÇ

ÏÖÓÐÒ»¸ö±íA
ÄÚÈÝÈçÏÂ

name  index  purview
СÍõ    1      3

±íB

    id  type  way
    1  Ê×Ò³  ÈκÎÈË
    2  Ê×Ò³  Òþ²Ø
    3  ÓéÀÖ  ½öºÃÓÑ
    4  ÓéÀÖ  ÈκÎÈË
ÏëÒª½á¹û£º
  name type  way  type  way
СÍõ    Ê×Ò³ ÈκÎÈË ÓéÀÖ ½öºÃÓÑ

---

SQL code:
select aa.name,aa.type,aa.way,bb.type,bb.way
(select a.name,b.type,b.way from a,b where a.index=b.id) aa,
(select a.name,b.type,b.way from a,b where a.purview=b.id) bb,
where aa.name=bb.name

---

×îºÃ±íÃû²»ÒªÓùؼü×Ö!

---

лл¥ÉϵĹØÐÄ£¬¹þ¹þ£¬ÎÒÊǾÙÀý£¬´ÓÀ´²»ÓÃ~~~~`

---

select aa.name,aa.type,aa.way,bb.type,bb.way
(select a.name,b.type,b.way from a,b where a.index=b.id) aa,
(select a.name,b.type,b.way from a,b where a.purview=b.id) bb,
where aa.name=bb.name
¶ÔµÄ

---

select aa.name,aa.type,aa.way,bb.type,bb.way from
(select a.name,b.type,b.way from a,b where a.index=b.id) aa,
(select a.name,b.type,b.way from a,b where a.purview=b.id) bb
where aa.name=bb.name

#1¥дµÄ©µô¶«Î÷~~~

---

»¹ÓиüºÃµÄ·½·¨Â𣿣¿~~~

---