select DISTINCT(p) FROM PersonFeature p JOIN p.MusicStyles m LEFT OUTER JOIN p.MyBlacklist m ...
Have two tables with same alias and don't throw exception or any error. And the result is not expected. So I realized the alias are equals and I changed one to 'mx', now the result is what I want.
The query below:
select DISTINCT(p) FROM PersonFeature p
JOIN p.MusicStyles m
LEFT OUTER JOIN p.MyBlacklist m ...
Have two tables with same alias and don't throw exception or any error. And the result is not expected.
So I realized the alias are equals and I changed one to 'mx', now the result is what I want.