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);