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