在android sqlite中加入两个表

本文介绍了在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