SQLiteDatabase db = getReadableDatabase();
String[] columns = new String[] { "storeInfo.storeNum", "storeInfo.nation","storeInfo.caegory","storeLocale.storeName", "storeLocale.sale" };
Cursor c = db.rawQuery("select storeInfo.storeNum storeInfo.nation , storeInfo.category , storeLocale.storeName , storeLocale.sale"
+" from storeInfo, storeLocale "
+" where storeInfo.storeNum = storeLocale.storeNum "
+" AND storeInfo.nation = 0"
+" AND storeInfo.category = 0"
+" AND storeLocale.language = 0", null);
에러로그
03-20 11:50:31.876: E/AndroidRuntime(16404): FATAL EXCEPTION: main
03-20 11:50:31.876: E/AndroidRuntime(16404): Process: freevergroup.freevercard, PID: 16404
03-20 11:50:31.876: E/AndroidRuntime(16404): java.lang.RuntimeException: Unable to start activity ComponentInfo{freevergroup.freevercard/freevergroup.freevercard.activities.Category_list}: android.database.sqlite.SQLiteException: near ".": syntax error (code 1): , while compiling: select storeInfo.storeNum storeInfo.nation , storeInfo.category , storeLocale.storeName , storeLocale.sale from storeInfo, storeLocale where storeInfo.storeNum = storeLocale.storeNum AND storeInfo.nation = '0' AND storeInfo.category = '0' AND storeLocale.language = '0'
03-20 11:50:31.876: E/AndroidRuntime(16404): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2436)
03-20 11:50:31.876: E/AndroidRuntime(16404): at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2495)
03-20 11:50:31.876: E/AndroidRuntime(16404): at android.app.ActivityThread.access$900(ActivityThread.java:170)
03-20 11:50:31.876: E/AndroidRuntime(16404): at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1304)
03-20 11:50:31.876: E/AndroidRuntime(16404): at android.os.Handler.dispatchMessage(Handler.java:102)
03-20 11:50:31.876: E/AndroidRuntime(16404): at android.os.Looper.loop(Looper.java:146)
03-20 11:50:31.876: E/AndroidRuntime(16404): at android.app.ActivityThread.main(ActivityThread.java:5635)
03-20 11:50:31.876: E/AndroidRuntime(16404): at java.lang.reflect.Method.invokeNative(Native Method)
03-20 11:50:31.876: E/AndroidRuntime(16404): at java.lang.reflect.Method.invoke(Method.java:515)
03-20 11:50:31.876: E/AndroidRuntime(16404): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1291)
03-20 11:50:31.876: E/AndroidRuntime(16404): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:1107)
03-20 11:50:31.876: E/AndroidRuntime(16404): at dalvik.system.NativeStart.main(Native Method)
03-20 11:50:31.876: E/AndroidRuntime(16404): Caused by: android.database.sqlite.SQLiteException: near ".": syntax error (code 1): , while compiling: select storeInfo.storeNum storeInfo.nation , storeInfo.category , storeLocale.storeName , storeLocale.sale from storeInfo, storeLocale where storeInfo.storeNum = storeLocale.storeNum AND storeInfo.nation = '0' AND storeInfo.category = '0' AND storeLocale.language = '0'
03-20 11:50:31.876: E/AndroidRuntime(16404): at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
03-20 11:50:31.876: E/AndroidRuntime(16404): at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:1113)
03-20 11:50:31.876: E/AndroidRuntime(16404): at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:690)
03-20 11:50:31.876: E/AndroidRuntime(16404): at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
03-20 11:50:31.876: E/AndroidRuntime(16404): at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:59)
03-20 11:50:31.876: E/AndroidRuntime(16404): at android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:37)
03-20 11:50:31.876: E/AndroidRuntime(16404): at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:44)
03-20 11:50:31.876: E/AndroidRuntime(16404): at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1438)
03-20 11:50:31.876: E/AndroidRuntime(16404): at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1377)
03-20 11:50:31.876: E/AndroidRuntime(16404): at freevergroup.freevercard.data.DataBaseManager.getStoreInfo(DataBaseManager.java:69)
03-20 11:50:31.876: E/AndroidRuntime(16404): at freevergroup.freevercard.activities.Category_list.onCreate(Category_list.java:66)
03-20 11:50:31.876: E/AndroidRuntime(16404): at android.app.Activity.performCreate(Activity.java:5580)
03-20 11:50:31.876: E/AndroidRuntime(16404): at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1093)
03-20 11:50:31.876: E/AndroidRuntime(16404): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2400)
2개의 테이블에서 검색하는방법인데 .에서 오류가났다고 나오네요 ... sqlite에서 2개의테이블검색하는 방법이 뭘까요 ㅠㅜ