2
Vote

RIGHT JOIN???

description

Anybody have idea to implement RIGHT JOIN in SharpHSQL engine.

SELECT S.StudentID, C.ClassID, C.ClassName, S.StudentName, SC.SchoolID, SC.SchoolName
FROM Student S
LEFT OUTER JOIN Class C
ON S.ClassID = C.ClassID
RIGHT OUTER JOIN School SC
ON SC.SchoolID = C.SchoolID

Thanks,

comments