query more than one table

[aoswald]

OK I already know the answer - yes I can query more than one table because I have done it before. But now as soon as I add the second table, I get no results in the query. I know there should be some results. what am I missing?

thanks

 

[Brianwarnock]

There is no match on the Join fields?

Brian

 

[aoswald]

yes there is