How do you do a self-join on a subselect ?
like SELECT a.x+b.x FROM (subselect) a, (subselect) b WHERE a.id = b.id+10
but without performing the subselect twice ..................................?