3.我现在如果建立了两个表
表一: id a b
1 a1 b1
1 a2 b2
2 a1 b1
2 a2 b2
表二: id x y
1 20 20
2 30 20
假设我输入a1,b1,怎么输出两组xy值,这个SQL语句该怎么设计,十分着急,谢谢
表一: id a b
1 a1 b1
1 a2 b2
2 a1 b1
2 a2 b2
表二: id x y
1 20 20
2 30 20
假设我输入a1,b1,怎么输出两组xy值,这个SQL语句该怎么设计,十分着急,谢谢
db.execSQL("CREATE TABLE IF NOT EXISTS " + loaderDataColumns.TABLE_NAME
+ " (" + loaderDataColumns.a + " integer,"
+ loaderDataColumns.b + " integer,"
+ loaderDataColumns.c + " TEXT,"
+ loaderDataColumns.d + " integer,"
+ loaderDataColumns.e + " TEXT,"
+ loaderDataColumns.f + " integer,"
+ loaderDataColumns.d + " integer)");