Hibernate本机查询在同一个表上有多个连接返回错误的结果

I am using a native sql query where I have a players table to which I join three times, first to get the batsman name, then to get bowler name and then to get the fielder name. Now the first join works, but the next two also return the same name i.e the batsman name.I am using a native sql query where I have a pl