Re: Query not displaying all data
We can't see what change you made to the SQL so we can't even guess whether or not you made the suggested change.
to be clear, an inner join will only return rows where there is a match in BOTH tables so if you didn't remove the inner join, you still have a problem. We can't guess what your schema is so we can't guess what the join should look like or even if it is possible to join those two tables. If they don't have a common field, then you can't join them.
Bridge Players Still Know All the Tricks