最近做项目遇到一个问题,外键关联查询,返回长度为1,但是值为 All elements are null没数据。
有两张表,分别为a表有数据,b表无数据。
select b.* from a as a left join b as b on b.a_id = a.id 发生异常
修正sql select b.* from a as a left join b as b on b.a_id = a.id where b.id is not null就可以避免这种情况。
select a.* from a as a left join b as b on b.a_id = a.id 无异常,
页面更新:2024-02-15
本站资料均由网友自行发布提供,仅用于学习交流。如有版权问题,请与我联系,QQ:4156828
© CopyRight 2020-2024 All Rights Reserved. Powered By 71396.com 闽ICP备11008920号-4
闽公网安备35020302034903号