sql code chunk right outer join

Publishing Your Results
1

I am trying to show the various joins in a class.

The following failed to knitr, even though the sql itself runs fine (PostgreSQL). Changing RIGHT to LEFT works fine. Any way to make RIGH join work in an R Markdown doc?

Right outer join
SELECT t1.*,t2.name2
FROM table1 t1 
RIGHT OUTER JOIN table2 t2
ON (t1.id=t2.id);
2

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.