How to Perform the following query using Greendao ?

android sql greendao
Rushi picture Rushi · Feb 5, 2014 · Viewed 7.8k times · Source

I have 2 tables A and B.

Table A contains names and table B contains selected names.

Now I would like to perform the following query on these tables using greendao, Please let me know if it is possible and if it is not are there any alternatives (maybe a raw query).

select * 
from A inner join B
on A.nameid = B.nameid

Also, Table A columns: id, nameid, name
and Table B columns: id, nameid, name, rating

Answer

Nevin Chen picture Nevin Chen · Feb 7, 2014

I think this might help. You can use the raw query as a fake join. And you get all you want in the Query object 

Query query = ATableDao.queryBuilder().where(
new StringCondition("nameid IN " +
"(SELECT nameid FROM B_Table )").build();

Since "nameid" doesn't seems to be a unique identifier in your sample. I won't suggest to use Relations to solve this issue. If you are try to use Relations, you can find my previous answer here.

Related questions

SQLite in Android How to update a specific row

I've been trying to update a specific row for a while now, and it seems that there are two ways to do this. From what I've read and tried, you can just use the: execSQL(String sql) method or the: …

Read More
Best way to work with dates in Android SQLite

I'm having some trouble working with dates on my Android application that uses SQLite. I have a couple questions: What type should I use to store dates in SQLite (text, integer, ...)? Given the best way to store dates how do …

Read More
Android SQLite: Update Statement

I need to implement SQLite in my application. I followed this tutorial.. Creating and using databases in Android one Everything is working fine. I inserted 1 row with 5 columns. Now I want to update value of 1 column only and others will …

Read More