I forgot to mention that you are right about how the inner join works; it only gives you records that match the where clause.
James