java - Adding a custom filter in a MyBatis left join

Question

We are using MyBatis to generate SQL using Java.

We need to do a left join on two tables ( t1 and t2) on certain columns. This is something mybatis allows easily.

Now we need some additional custom filter which we need to pass on this join so that expected output is

select t1.x, t2.y
from t1 left join t2 on
t1.a=t2.a  // this is fine
and t2.b="xyz"  // how to do this ?
where t1.c="def"

To create a left join we are using

QueryExpressionDSL.leftJoin()
.on(...)
.and(...) etc

Answer 1

等待大神答复