ÇëÒ»ÌõSQLÓï¾ä

ÈçÏÂ
code mc lx
1 aa FK
2 bb FK
3 cc HK
4 dd HK
ÒªÇóÉú³É:
code mc code mc
1 aa 3 cc
2 bb 4 dd

---

SQL code:
select t1.code, t1.mc,t2.code, t2.mc
from tb t1 left join tb t2
on t1.code=t2.code
where t1.code%2=1 and t2.code%2=0;

---

SQL code:
create table tb(code int,mc varchar(10),lx varchar(10))
insert INTO tb select
1 ,'aa','FK' union all select
2 ,'bb','FK' union all select
3 ,'cc','HK' union all select
4 ,'dd','HK'



select t1.code,t1.mc,t2.code,t2.mc
from tb t1,tb t2
where t2.code=t1.code+2

/*code mc code mc
----------- ---------- ----------- ----------
1 aa 3 cc
2 bb 4 dd

(2 ÐÐÊÜÓ°Ïì)

*/

---

SQL code:
--ºÇºÇ£ºÉÙÁ˸ö¼Ó2
select t1.code, t1.mc,t2.code, t2.mc
from tb t1 left join tb t2
on t1.code=t2.code+2
where t1.code%2=1 and t2.code%2=0;

---

SQL code:
select t1.code,t1.mc,t2.code,t2.mc
from tb t1,tb t2