本文介绍了在android sqlite中加入两个表的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试加入表格
i am trying to join tables with
SELECT TOP (1) DEPhysician.FullName, DEPatientVisitTemp.Diagnosis, DEStimulator.AssignDate, DEPatientVisitTemp.VisitDate, DEPatientVisitTemp.VisitReason, DEPatientVisitTemp.StimulationOnVAS, DEPatientVisitTemp.StimulationOffVAS, DEPatientVisitTemp.PatientID FROM DEPhysician RIGHT OUTER JOIN DEStimulatorGroup INNER JOIN DEPatientVisitTemp ON DEStimulatorGroup.StimulatorGroupID = DEPatientVisitTemp.StimulatorGroupID INNER JOIN DEStimulator ON DEStimulatorGroup.StimulatorGroupID = DEStimulator.StimulatorGroupID ON DEPhysician.PhysicianID = DEPatientVisitTemp.PhysicianID WHERE (DEPatientVisitTemp.PatientID = @PatientID) ORDER BY DEPatientVisitTemp.VisitDate DESC获得异常,例如
getting exception like
android.database.sqlite.SQLiteException: RIGHT and FULL OUTER JOINs are not currently supported (code 1): , while compiling: SELECT TOP (1) FullName, Diagnosis, AssignDate, VisitDate, VisitReason, StimulationOnVAS, StimulationOffVAS, PhysicianID FROM falcondba RIGHT OUTER JOIN falcondbb INNER JOIN falcondbe ON StimulatorGroupID = StimulatorGroupID INNER JOIN falcondbf ON StimulatorGroupID = StimulatorGroupID ON PhysicianID = PatientID WHERE (PatientID = ) ORDER BY VisitDate DESC 04-03 12:25:33.795: E/AndroidRuntime(13775): at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)推荐答案
错误是自我-explanatory。 不支持RIGHT和FULL OUTER JOINS。 因为我不明白你的查询很多,我用简单的例子回答你。 见, SELCT e.EmpName,E.DOB,e.Salary,d 。部门WHERE e.DeptID = d.DeptID和e.EmpID = 1 尝试类似于我上面提到的内容。它将解决您的问题。 -KR Error is self-explanatory. RIGHT and FULL OUTER JOINS are not supported. As I don't understand your query much, I'm answering you with simple example. See, SELCT e.EmpName, E.DOB, e.Salary, d.Department WHERE e.DeptID = d.DeptID AND e.EmpID = 1 Try something like I have mentioned above. It will solve your problem. -KR
更多推荐
在android sqlite中加入两个表
发布评论