sqlite 不支持 多表联合查询语句

plus.sqlite.selectSql
不支持 下面这样的语句查询。
select a.key,a.lineGuid,a.modeltype,a.modeltitle, b.modelpath as offlinepath from a, b where a.lineGuid = modelfilelist.lineGuid and a.key in ("42ba47a5-820f-4e8d-8729-00ad406b", "fe7a9bbf-34e-40eb-aae5-20fbe406");