select a.*,b.结算时间 from A a,B b where a.住院号=b.住院号 and b.结算时间 between '20060324' and '20060325' order by a.住院号,a.金额没测试过,有错楼下的更正
select 表a.住院号,表a.姓名, 表a.项目, 表a.金额,表b.结算时间 from 表a,表b where 表a.住院号=表B.住院号 and to_char(结算时间,'yyyymmdd')>='20060324' and to_char(结算时间,'yyyymmdd')<='20060325'
select 表a.住院号,表a.姓名, 表a.项目, 表a.金额,表b.结算时间 from 表a,表b where 表a.住院号=表B.住院号 and to_char(结算时间,'yyyymmdd')> between '20060324' and '20060325'
select 表a.*, ,表b.结算时间 from 表a,表b where 表a.住院号=表B.住院号 and to_char(结算时间,'yyyymmdd')> between '20060324' and '20060325'
where a.住院号=b.住院号
and b.结算时间 between '20060324' and '20060325'
order by a.住院号,a.金额没测试过,有错楼下的更正
from 表a,表b
where 表a.住院号=表B.住院号
and to_char(结算时间,'yyyymmdd')>='20060324'
and to_char(结算时间,'yyyymmdd')<='20060325'
from 表a,表b
where 表a.住院号=表B.住院号
and to_char(结算时间,'yyyymmdd')> between '20060324' and '20060325'
from 表a,表b
where 表a.住院号=表B.住院号
and to_char(结算时间,'yyyymmdd')> between '20060324' and '20060325'