Hi Scott

Hope this migth give you a better understanding

http://w3schools.com/sql/sql_join_inner.asp