tryselect c.*,a.*
from 病人表 a
inner join 病人病历表 b on a.病人ID=b.病人ID
inner join 医生表 c on b.医生ID=c.医生ID
inner join 医院表 d on c.医院ID=d.医院ID
from 病人表 a
inner join 病人病历表 b on a.病人ID=b.病人ID
inner join 医生表 c on b.医生ID=c.医生ID
inner join 医院表 d on c.医院ID=d.医院ID
" from DPatientInfo a left join " +
" DPatientCaseInfo b where a.nid = b.patient.nid left join " +
" DDoctorInfo c where b.doctor.nid = c.nid left join " +
" DHospitalInfo d where c.hospital.nid = 34");
select a.*" +
" from DPatientInfo a left join " +
" DPatientCaseInfo b on a.nid = b.patient.nid left join " +
" DDoctorInfo c on b.doctor.nid = c.nid left join " +
" DHospitalInfo d on c.医院ID=d.医院ID where c.hospital.nid = 34楼主java很厉害吧,能交流交流不? 呵呵!