I used LEFT JOIN to add some values to a table, but the values that I want only appear if I use RIGHT JOIN, in the other hand if I use RIGHT JOIN I can only get the value that I don't get if I use LEFT JOIN
Better to post some sample data so that we can help you.
You can also look for some books for SQL/Oracle in http://booknabber.com/shop/
It looks like you're new here. If you want to get involved, click one of these buttons!