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
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)
SELCT e.EmpName, E.DOB, e.Salary, d.Department WHERE e.DeptID = d.DeptID AND e.EmpID = 1
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)