使用SQLiteQueryBuilder联接两个表

本文介绍了使用SQLiteQueryBuilder联接两个表的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我正在尝试使用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.