Whenever confusion sets in I usually use the View designer on a few small tables and play with it until I achieve the desired results. Then simply copy the SQL statement from the view designer. Of course, making any necessary changes to accomodate SQL syntax.