SQLiteQueryBuilder queryBuilder = new SQLiteQueryBuilder();
  queryBuilder.setTables(SITE.SITE_TABLE_NAME +", " +ID.ID_TABLE_NAME 
    +"," +PWD.PWD_TABLE_NAME
    );
  queryBuilder.appendWhere(SITE.SITE_TABLE_NAME + "." + SITE.ID_TYPE_ID + "=" +ID.ID_TABLE_NAME + "." + ID._ID +"=" +PWD.PWD_TABLE_NAME + "." + PWD._ID);
  
  
  // Get the database and run the query
        SQLiteDatabase db = mDatabase.getReadableDatabase();
        String asColumnsToReturn[] = { SITE.SITE_TABLE_NAME + "." + SITE.SITE_NAME, SITE.SITE_TABLE_NAME + "." + SITE._ID, 
          ID.ID_TABLE_NAME + "." +ID.ID_TYPE_NAME,
          PWD.PWD_TABLE_NAME +"." + PWD.PWD_TYPE_NAME };
        Cursor c = queryBuilder.query(db, asColumnsToReturn, null, null, null, null, SITE.DEFAULT_SORT_ORDER);

위에는 쿼리처리하는부분..이고요.

// SITE table
    public static final class SITE implements BaseColumns {

        private SITE() {}
        
        public static final String SITE_TABLE_NAME = "table_SITE";
        
        public static final String SITE_NAME = "site_name";
        public static final String ID_TYPE_ID = "id_name_id";
      public static final String PWD_TYPE_ID = "pwd_name_id";
        public static final String DEFAULT_SORT_ORDER = "site_name ASC";
   
    }
    
    
    
    // ID Type table
    public static final class ID implements BaseColumns {

        private ID() {}
        
        public static final String ID_TABLE_NAME = "table_ID";
        
        public static final String ID_TYPE_NAME = "id_name";
        
        public static final String DEFAULT_SORT_ORDER = "id_name ASC";
    }
    // PWD Type table
    public static final class PWD implements BaseColumns {

        private PWD() {}
        
        public static final String PWD_TABLE_NAME = "table_PWD";
        
        public static final String PWD_TYPE_NAME = "pwd_name";
        
        public static final String DEFAULT_SORT_ORDER = "pwd_name ASC";
    }

이건 테이블 작성.

인데요..


이게 결과 화면입니다.
첫번째에 1,11,111 입력하고 두번째에 2,22,222 입력을 했는데요.

 SITE,ID 테이블은 잘 들어가고 잘 나오는데.. 세번째 PWD 테이블이 첫번쨰 입력된 내용만을 불러와버리는데

어디가 잘못된건지좀 ㅠ ㅠ알려주세요

:: Pet tracker 수정한거라서..;;
중간중간에 이상할수도 있씁니다..ㅠ