select Tab1.a,Tab1.b,Tab2.a,Tab2.b from (select a,b from XX where a=x) Tab1, (select a,b from XX where b=y) tab2 where tab1.a=xxx, tab2.b = yyy
----------------------------------------------
网络,数据库,IOCP应用,API应用等,欢迎交流: http://blog.163.com/huangjian_w/
select a.km,a.score,b.km,b.score from (select * from tablename where km='英语') as a,(select * from tablename where km='数学') as a
----------------------------------------------
好好学习,天天向上! →我: ●-(不许动!) ● ←:你: █┳ ┗█┛ ┏┓ ┛┗