Just a hunch given I can't know the actual data, but it could be that you need left/right joins rather than inner ones. The query you use will only return rows if all the conditions match for all tables. If one table has no matching rows, then the query will not return anything.

Worth a look anyway.

Duncan