我使用mybatis从mysql查询数据,我有一个sql,如下所示:
select t1.a , t1.b , t2.c, (select d from C t3 where t1.e=t3.e limit 1) as d
from A t1 left join B t2 on t1.x = t2.x
where ...
我发现“d”列的返回值总是空的。然后我改变了列的顺序,最后放了'c',这次'c'是空的,而'd'不是空的
用mybatis3测试,springboot 2.15
我使用mybatis从mysql查询数据,我有一个sql,如下所示:
select t1.a , t1.b , t2.c, (select d from C t3 where t1.e=t3.e limit 1) as d
from A t1 left join B t2 on t1.x = t2.x
where ...
我发现“d”列的返回值总是空的。然后我改变了列的顺序,最后放了'c',这次'c'是空的,而'd'不是空的
用mybatis3测试,springboot 2.15
暂无答案!
目前还没有任何答案,快来回答吧!