Could you illustrate your issue with couple of screenshots?
What are you connecting to? How does the join look like? What do you get if you just put "Number of Records" on the shelf?
What is your database?
What's the data type (in the database) for OBJ_ID in both tables?
There's either data mismatch (extra spaces, casing) or data type mismatch (like variable length vs fixed length).