Query with joins repeats first match

i am facing a problem in a join query .
it contains multiple joins .
the output for example is like ,

10 abc 123

10 abc 123

10 abc 123

and so on …

i tried it with and without indexing .
but the result set is the same.
the first match in the query is repeated .
the tables are Innodb type , which would also permit foreign key.
i am working on version 5.0

You should supply your schema and explain for your query if you want reasonable answer.

Sir ,
Please see attached Explain result.
And i hope it is useful.

Hi,
i found out the issues that were leading to it.
1: redundant data in one of the tables .
2: Use of IS NULL in conditions.

So the JOINS work normally . And i also have to say it is fast .

thanks.