我有一个这样的sql查询
String loadFav = "SELECT _id, title, name, favorite FROM table1 where favorite= 1 "
+ "UNION ALL"
+ "SELECT _id, title, name, favorite FROM table2 where favorite= 1"
;
Cursor mCursor = mSQLiteDatabase.rawQuery(loadFav, null);
运行此查询时出现错误。它的结构正确吗?有人能帮我吗?
始终通过查看 SQL 字符串来排除故障——而不是构建 SQL 字符串的代码!
SELECT _id, title, name, favorite FROM table1 where favorite= 1 UNION ALLSELECT _id, title, name, favorite FROM table2 where favorite= 1
您之间需要一个空格ALL
和第二个SELECT
.
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)