select group_table.name from group_table
inner join department_table
on group_table._id = department_table.group_id
inner join relationship_table
on department_table._id = relationship_table.department_id
where relationship_table.user_id = ?
Android sqlite 三表查询
Author: wangsy
Link: https://wangsy.me/2013/csdn-11877337-8ddb03bf/
本文采用知识共享署名-非商业性使用 4.0 国际许可协议进行许可