RIGHT JOIN, changed default behaviour of JOIN

Added RIGHT JOIN
Changed default behaviour of JOIN from LEFT JOIN to INNER JOIN