android sqlite联合,在联合查询中，Android SQLite"order by" 计算列_sql_开发99编程知识库...

我使用下面的代码查询一个表：public Cursor fetchFilteredItemsNearSortedByDistance(String strTable, String[] strArrayFields, String strField, String strCriterion, double dblCentreEasting, double dblCentreNorthing, double dblRadius) {

String strSQL ="Easting>" + Double.toString(dblCentreEasting-dblRadius);

strSQL +=" AND Easting

strSQL +=" AND Northing>" + Double.toString(dblCentreNorthing-dblRadius);

strSQL +=" AND Northing

strSQL +=" AND" + strField +" LIKE '%" + strCriterion +"%'";

strSQL +=" ORDER BY";

strSQL +="((Easting -" + Double.toString(dblCentreEasting)+")";

strSQL +=" * (Easting -" + Double.toString(dblCentreEasting)+")";

strSQL +=" + (Northing -" + Double.toString(dblCentreNorthing)+")";

strSQL +=" * (Northing -" + Double.toString(dblCentreNorthing)+"))";

strSQL +=" COLLATE NOCASE";

return myDbHelper.myDataBase.query(strTable, strExtendedArrayFields, strSQL, null, null, null, null);

}

上代码工作正常。 但是，我现在想将该想法扩展到两个或者更多表的联合，并尝试了以下代码：public Cursor fetchFilteredPOIsNearSortedByDistance(String strTable, String[] strArrayFields, String strField, String strCriterion, double dblCentreEasting, double dblCentreNorthing, double dblRadius) {

String strSQL ="SELECT * FROM TableA";

strSQL +="UNION SELECT * FROM TableB";

strSQL +="WHERE ( Easting>" + Double.toString(dblCentreEasting-dblRadius);

strSQL +=" AND Easting

strSQL +=" AND Northing>" + Double.toString(dblCentreNorthing-dblRadius);

strSQL +=" AND Northing

strSQL +=" AND" + strField +" LIKE '%" + strCriterion +"%' )";

strSQL +=" ORDER BY";

strSQL +="((Easting -" + Double.toString(dblCentreEasting)+")";

strSQL +=" * (Easting -" + Double.toString(dblCentreEasting)+")";

strSQL +=" + (Northing -" + Double.toString(dblCentreNorthing)+")";

strSQL +=" * (Northing -" + Double.toString(dblCentreNorthing)+"))";

strSQL +=" COLLATE NOCASE";

return myDbHelper.myDataBase.rawQuery(strSQL, null);

}

但是，这会产生一个"SQLiteException: 1st ORDER BY 项与结果集中的任何列都不匹配"错误。

valueStack中的完整错误为：ERROR/AndroidRuntime(11444): Caused by: android.database.sqlite.SQLiteException: 1st ORDER BY term does not match any column in the result set:, while compiling: SELECT * FROM TableA UNION SELECT * FROM TableB WHERE ( Easting> 594378.8427734375 AND Easting <663822.8427734375 AND Northing> 127586.046875 AND Northing <197030.046875 AND Name LIKE '%%' ) ORDER BY ((Easting - 629100.8427734375) * (Easting - 629100.8427734375) + (Northing - 162308.046875) * (Northing - 162308.046875)) COLLATE NOCASE

谁能帮我到正确的轨道上？