SQL query on M:N relation

I was told that there may return some dulipcate records when a select table join on M:N relationship tables, but I cannot find out what situation would be.

I would like to know if it is true, and in what situation ? Thanks a lot.