Can you post the actual queries you are building, it could help. We also need the schema of the tables involved.

We do not know what tables you are using, or whatever field you are joining on, help us help you! 😉