这两个查询语句怎么写？

[abinnet]

表owner:
xm bh htje xsrq tfrq
张三 1 2600 2004-10-11
李四 2 2500 2004-08-01 2004-10-15
王五 3 2400 2004-09-10

表money：
bh rq kxmc je
1 2004-10-11 工资 230
1 2004-10-21 工资 370
1 2004-10-11 奖金 60
2 2004-09-01 工资 250
2 2004-09-01 福利 230
2 2004-10-02 工资 -250
2 2004-10-02 福利 -50
3 2004-10-02 工资 250
3 2004-10-02 福利 150

(两表bh字段关连)

问题一：如何显示owner.xsrq > min(money1.rq) 的owner的记录。

问题二：如何得到下表：

xm htje xsrq yc wc
张三 2600 2001-10-11 600 2000
王五 2400 2004-09-10 250 2150

说明
1、统计owner.xsrq<='2004-10-31' and not(owner.tfrq<='2004-10-31')
2、结果表中yc为在money中bh等于owner.bh，kxmc=工资,rq <='2004-10-31' 的je合计
3、结果表中wc为owner.htje - yc

[lsxaa]

select * from owner a
where not exists(select 1 from money1 where bh=a.bh and rq<a.xsrq)

[lsxaa]

select a.xm,a.htje,a.xsrq,
yc=sum(case b.kxmc when '工资' then b.je else 0 end),
wc=a.htje-sum(case b.kxmc when '工资' then b.je else 0 end)
from owner a inner join money1 b on a.bh=b.bh and b.rq <='2004-10-31'
group by a.xm

[lanbaibai]

select * from owner a ,money1 b where bh=a.bh and rq<a.xsrq

[lsxaa]

第一个应该是这样

select * from owner a
where xsrq>(select min(rq) from money1 where bh=a.bh )

[vinsonshen]

lsxaa(小李铅笔刀) ，第二个也不行吧？

[davorsuker39]

问题一:
select a.* from owner a join money b
on a.xsrq>min(b.rq) and a.bh=b.bh

问题二:
select a.xm,a.htje,a.xsrq,
yc=sum(case b.kxmc when '工资' then b.je else 0 end),
wc=a.htje-sum(case b.kxmc when '工资' then b.je else 0 end)
from owner a join money1 b on a.bh=b.bh and b.rq <='2004-10-31'
group by a.xm

[lsxaa]

回复人： vinsonshen(有空多来，努力升星~~) ( ) 信誉：95 2004-11-22 10:58:00 得分: 0


lsxaa(小李铅笔刀) ，第二个也不行吧？


呵呵 第二个那里不行呢???