How do I decide when to use right joins/left joins or inner joins. Or how to determine which table is on which side?

Hi...

HTH found a link...

all goes here

http://stackoverflow.com/questions/3308122/how-do-i-decide-when-to-use-right-joins-left-joins-or-inner-joins-or-how-to-det