在android sqlite中加入两个表 [英] joining two tables in 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中加入两个表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！