A couple of things to keep in mind with join, Inner joins can be "dangerous" since they can drop data, so always make sure your using the correct keys. Avoid Right joins when possible. Also think about the relationship of the tabes, 1-1, 1 to many and many to many.