That was it, changing the join to a left outer join did the trick. Thanks so much for your help. Sorry about the table names, come from the...

Thank you for the quick response. I tried the query you wrote, and it runs with no error, however it returns no results either. I am not sure...