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
It looks like you're new here. If you want to get involved, click one of these buttons!
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/