天天看点

CDS view里inner join, left outer join和association的区别

Inner join source code:

CDS view里inner join, left outer join和association的区别

Those user status without corresponding entries in tj02t will NOT be displayed in result set:

CDS view里inner join, left outer join和association的区别

change inner join to left outer join, the result are opposite:

CDS view里inner join, left outer join和association的区别

Association has the same behavior with left outer join:

CDS view里inner join, left outer join和association的区别

继续阅读