most likely the issue is with the join.
when using the INNER JOIN type, there mu st be a match on both sides of the join to return a result. If one of the tables does not a record in it to satisfy the join, no result will be returned.
Double check to make sure that there is data to satisfy the join in all of the tables being joined.