title: PreparedStatment with a Left Join
body: <p>I am not sure if it is possible, but I want to create an insert query for a prepared-statement where the insert query consist of a join between two tables.</p>
  
  <p>E.g. (perhaps a stupid example) </p>
  
  <pre><code>String sql = "INSERT INTO TABLE_A A (" + 
               "GenderId, Name, Surname, Age) VALUES (B.GenderId, ?, ?, ?) " + 
               "LEFT JOIN TABLE_B B ON A.GenderId = B.GenderId " + 
               "WHERE B.Gender = 'Male'";
  
  PreparedStatement statement = conn.prepareStatement(sql);
  statement.setString(1, "Bill");
  statement.setString(2, "Gates");
  statement.setInt(3, 50);
  </code></pre>