SELECT tb.* FROM ATable AS n JOIN BTable AS tb ON n.fileId = tb.fileId AND n.albumId = ? AND (tb.columnId IN (?) OR (tb.day IN (?) AND tb.columnId NOT IN (?))) resultSet = await db.querySql(sqlString,args)
此时,第二个参数怎么传入,试了直接传入number数组不行,以逗号拼接也不行,但是不用问号占位,直接硬编码可以。
使用: