select a.PATIENT_ID, a.VISIT_ID, a.ST_DATE, a.ST_OPERATOR, a.END_DATE, a.END_OPERATOR,
a.COMMUNICATION, a.IMPAIRED, a.INEFFECTIVE, a.UMSB, a.ASPHYXIA, a.SLEEP,
a.RESPIRATORY, a.INEFFICIENT, a.SKIN, a.INTEGRITY, a.HUMORAL, a.SWALLOWING,
a.TEMPERATURE, a.AWARENESS, a.MALNUTRITION, a.WARDCODE
from MED_NANZONG_CAREMEASURES a
left outer join
(select min(ST_DATE) as ST_DATE,COMMUNICATION from MED_NANZONG_CAREMEASURES
group by COMMUNICATION ) b
on a.COMMUNICATION = b.COMMUNICATION WHERE (PATIENT_ID = '查询条件') AND (VISIT_ID = '查询条件') AND (WARDCODE='查询条件')
order by b.st_date, a.st_date,a.COMMUNICATION我机器上是oracle10 没有问题 但是到oracle8的数据库上就会出错... 要怎么修改才能在8上执行 谢谢
a.COMMUNICATION, a.IMPAIRED, a.INEFFECTIVE, a.UMSB, a.ASPHYXIA, a.SLEEP,
a.RESPIRATORY, a.INEFFICIENT, a.SKIN, a.INTEGRITY, a.HUMORAL, a.SWALLOWING,
a.TEMPERATURE, a.AWARENESS, a.MALNUTRITION, a.WARDCODE
from MED_NANZONG_CAREMEASURES a
left outer join
(select min(ST_DATE) as ST_DATE,COMMUNICATION from MED_NANZONG_CAREMEASURES
group by COMMUNICATION ) b
on a.COMMUNICATION = b.COMMUNICATION WHERE (PATIENT_ID = '查询条件') AND (VISIT_ID = '查询条件') AND (WARDCODE='查询条件')
order by b.st_date, a.st_date,a.COMMUNICATION我机器上是oracle10 没有问题 但是到oracle8的数据库上就会出错... 要怎么修改才能在8上执行 谢谢
这个是最先的写法,8i之前的要把Join条件写成这样的(+)