三个表关联查询，例如A表作为主表 A表的外键，关联B表，B表的外键关联C表，这种关联查询该怎样做？ #409
Description
环境信息
- 系统:
- JDK:
- 数据库:
- APIJSON:
问题描述
SQL的查询如下：
select r.id from roster r
left join sub_acct sa on r.company_id = sa.company_id
left join main_acct ma on ma.main_account = sa.main_account
where ma.open_card_file = 1 ;
我的写法如下：
{
"sql@": {
"from": "sub_acct",
"join": "</main_acct/main_account@",
"sub_acct": {
"@schema": "ziyoutong",
"@column": "company_id",
},
"main_acct": {
"@schema": "ziyoutong",
"main_account@": '/sub_acct/main_account',
"open_card_file": 1,
"@column": "",
},
},
"[]": {
"query": 2,
"roster": {
"@schema": "ziyoutong",
"@column": "id",
"@group": "id_card,self_employed_state",
"@use": "ziyoutong",
"@order": "id_card-",
"company_id{}@": {
"from": "company_info",
"company_info": {
"@schema": "ziyoutong",
"is_delete": 0,
"@column": "company_id",
"company_id{}@": "sql",
}
},
},
}查询没有报错，但查询出来数据不对。open_card_file = 1 ，这个条件没有作用，没有筛选出来。所以不知道是不是我的写法有问题，希望能给予解答。谢谢
错误信息