使用SQLiteQueryBuilder联接两个表 [英] Using SQLiteQueryBuilder to join two tables

问题描述

我正在尝试使用Android SDK的SQLiteQueryBuilder联接两个表，我们将它们称为t1和t2，然后根据每个表的属性(例如t1.att1和t2.att2)来查询该表，该属性等于某个值.当涉及到选择时，我对语法有些困惑.感谢您的帮助.谢谢！

I'm trying to use Android SDK's SQLiteQueryBuilder to join two tables, let's call them t1 and t2, and query that table based on an attribute from each table, say t1.att1 and t2.att2, equaling a certain value. I'm a little confused on the syntax when it comes to the selection. Help is appreciated. Thanks!

推荐答案

以下是如何将QueryBuilder用于INNER JOIN.

Here is how you can use QueryBuilder for INNER JOIN.

  SQLiteQueryBuilder queryBuilder = new SQLiteQueryBuilder();
  queryBuilder.setTables("t1 INNER JOIN t2 ON t1.ID=t2.ID");
  queryBuilder.query(db, new String[]{"t1.att1", "t2.att2"}, "t1.att1=? AND t2.att2=?", new String[]{"value1","value2"}, null, null, null);

"value1"和"value2"将替换为正确的值.

"value1" and "value2" are to be replaced with correct values.

这篇关于使用SQLiteQueryBuilder联接两个表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！