You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
如easyEntityQuery.queryable(BlogEntity.class)
.leftJoin(Topic.class, (t_blog, t_topic) -> t_blog.id().eq(t_topic.id()))
.select((t_blog, t_topic) -> new TopicAndBlogVOProxy()
.column1().set(t_blog.title()) //列1
.column2().set(t_topic.title()) //列2
)
.where(o -> o.column1().eq("3"))
.toList();
原来生成的是
select column1,column2 from (SELECT
t.title AS column1,
t1.title AS column2
FROM t_blog t
LEFT JOIN t_topic t1
ON t.id = t1.id )
where column1 = '3'
如果开启where内置期望生成 select column1,column2 from (SELECT
t.title AS column1,
t1.title AS column2
FROM t_blog t
LEFT JOIN t_topic t1
ON t.id = t1.id
where t.title = '3') t