title: How to apply clause on right table in JPA left join
body: <p>I have 2 tables i.e. User and UserWallet now i want to create query in JPA in respect to sql query :-</p>
  
  <pre><code>working SQL query:-
  SELECT * FROM user u left join user_wallet uw on u.id=uw.user_id and uw.wallet_type=2 where u.id = 2;
  </code></pre>
  
  <p>JPA query:-</p>
  
  <pre><code>not working:-
  select w.address as walletAddress,u.id as id from User u left join u.userWallets w  w.walletType=2 where u.id=:id
  </code></pre>