Please show us the sql script that you're using.

Perhaps you're using an incorrect left or right join on a table?? We can's say for sure without seeing your code.