mysql 多重查询

SELECT aa.value-bb.value FROM (SELECT * FROM a WHERE (a.`id`)%2<>0 )aa ,(SELECT * FROM a WHERE (a.`id`)%2 =0) bb WHERE aa.id=bb.id-1;