这样试试?你用的什么数据库?
select A.hospitalId,A.MRId,A.FromDate,A.ToDate ,[B.name]
From s_HosActor A,s_Hospital B,s_Employee C,s_WorkGroup D,s_Office E
Where [E.id]='05' And A.hospitalId=[B.ID] And A.MRid=[C.ID] And C.GroupID=[D.ID] AND D.OfficeID=[E.id]
select A.hospitalId,A.MRId,A.FromDate,A.ToDate ,[B.name]
From s_HosActor A,s_Hospital B,s_Employee C,s_WorkGroup D,s_Office E
Where [E.id]='05' And A.hospitalId=[B.ID] And A.MRid=[C.ID] And C.GroupID=[D.ID] AND D.OfficeID=[E.id]
救命啊!!!!!!!!!!!!
用ado的recordset的open方法就是出错,
告诉我sql语句某个地方错了!
没啧!!!
我问别人,也说遇到过!!!
却不知道什么原因!!!