select pio.* from tb_process_info pio where
not exist (select * from (select * from (select PatientId, ProcessId,DiseaseCode,UpdateDate,count(Status) cntStatus from tb_process_info group by PatientId, ProcessId,DiseaseCode,UpdateDate) info where cntStatus>1) pii
where pii.PatientId=pio.PatientId and pii.ProcessId=pio.ProcessId and pii.DiseaseCode=pio.DiseaseCode and pii.UpdateDate=pio.UpdateDate)运行后,报第二个select出错,里面的字段我保证都是有的,以前很少用exist,现在竟然不知道怎么用了,郁闷
not exist (select * from (select * from (select PatientId, ProcessId,DiseaseCode,UpdateDate,count(Status) cntStatus from tb_process_info group by PatientId, ProcessId,DiseaseCode,UpdateDate) info where cntStatus>1) pii
where pii.PatientId=pio.PatientId and pii.ProcessId=pio.ProcessId and pii.DiseaseCode=pio.DiseaseCode and pii.UpdateDate=pio.UpdateDate)运行后,报第二个select出错,里面的字段我保证都是有的,以前很少用exist,现在竟然不知道怎么用了,郁闷
select pio.* from tb_process_info pio where
not exists (select * from (select * from (select PatientId, ProcessId,DiseaseCode,UpdateDate,count(Status) cntStatus from tb_process_info group by PatientId, ProcessId,DiseaseCode,UpdateDate) info where cntStatus>1) pii
where pii.PatientId=pio.PatientId and pii.ProcessId=pio.ProcessId and pii.DiseaseCode=pio.DiseaseCode and pii.UpdateDate=pio.UpdateDate)
not exist (select * from (select * from (select PatientId, ProcessId,DiseaseCode,UpdateDate,count(Status) cntStatus from tb_process_info group by PatientId, ProcessId,DiseaseCode,UpdateDate) info where cntStatus>1) pii
where pii.PatientId=pio.PatientId and pii.ProcessId=pio.ProcessId and pii.DiseaseCode=pio.DiseaseCode and pii.UpdateDate=pio.UpdateDate)-----------------------------------------------------------------
select pio.* from tb_process_info pio where
not exists (select * from (select * from (select PatientId, ProcessId,DiseaseCode,UpdateDate,count(Status) cntStatus from tb_process_info group by PatientId, ProcessId,DiseaseCode,UpdateDate) info where cntStatus>1) pii
where pii.PatientId=pio.PatientId and pii.ProcessId=pio.ProcessId and pii.DiseaseCode=pio.DiseaseCode and pii.UpdateDate=pio.UpdateDateexist-->exists
from tb_process_info pio
where not exists
(
select * from
(
select * from
(
select PatientId, ProcessId,DiseaseCode,UpdateDate,count(Status) cntStatus
from tb_process_info
group by PatientId, ProcessId,DiseaseCode,UpdateDate
) info
where cntStatus>1
) pii
where pii.PatientId=pio.PatientId and pii.ProcessId=pio.ProcessId and
pii.DiseaseCode=pio.DiseaseCode and pii.UpdateDate=pio.UpdateDate
)