且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

在SELECT * FROM错误的android声明SQLite数据库

更新时间:2023-12-01 13:51:10

您的where子句引用称为一个对象,你有没有在你的FROM子句了。此外,没有多少点,如果你不使用别名混淆你的表..

Your where clause references an object called Table which you haven't got in your FROM clause. Also, there's not much point in aliasing your tables if you're not using the aliases..

我猜测它应该是:

private final String MY_QUERY = "SELECT * FROM wwTable INNER JOIN wwTimeTable ON wwTable._id=wwTimeTable.mName WHERE wwTable._id=wwTimetable.mForeign";