Inner join source code:
![](https://img.laitimes.com/img/__Qf2AjLwojIjJCLyojI0JCLicmbw5CN2QTOkRzNhZmMkR2YmBjYhdjN0E2NmdjMzYTMyQGM38CX5d2bs92Yl1iclB3bsVmdlR2LcNWaw9CXt92Yu4GZjlGbh5yYjV3Lc9CX6MHc0RHaiojIsJye.png)
Those user status without corresponding entries in tj02t will NOT be displayed in result set:
change inner join to left outer join, the result are opposite:
Association has the same behavior with left outer join:
Inner join source code:
Those user status without corresponding entries in tj02t will NOT be displayed in result set:
change inner join to left outer join, the result are opposite:
Association has the same behavior with left outer join: