android sqlite help to fire my own query?

Question

hello guys i have a simple intersect query works fine for sqlite3 console on windows But how can i fire it and retrieve results in android sqlite database.

eg.

 SELECT b_name FROM bus,route,station WHERE s_name='STAITON_NAME'
 AND route.b_id=bus.b_id AND route.s_id=station.s_id INTERSECT
 SELECT b_name FROM bus,route,station WHERE s_name='STATION_NAME' AND route.b_id=bus.b_id AND route.s_id=station.s_id;

yes it is one query but has intersect in between this means i need to pass two different STATION_NAMES... so how could it be... — user3139338, Feb 22 '14 at 19:39
[SQLiteDatabase.rawQuery\(\)](http://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html) — chalup, Feb 22 '14 at 20:12

score 0 · Answer 1 · answered Feb 22 '14 at 20:51

To fire a query, use rawQuery. To pass two different station names, use two different parameters:

c = db.rawQuery("SELECT ... WHERE s_name = ? AND ..."+
                       "... WHERE s_name = ? AND ...",
                new String[] { station1, station2 });

android sqlite help to fire my own query?

1 Answers1