难道，查询

[sun992]

select name ,xp,sfzh,je,lj from dirname where yearf='200302'
select je-lj as lj from dirname where yearf<'200302'

把两个查询的结果联起来，怎么做呢,
name char(20)
xp char(4)
sfzh char(18)
je float(8)
lj float(8)
没有主健怎么连