join ex.

    private void sendListMessage(Messenger msgr, int mode) {
        /*
        public static final String COLUMN_NAME = "job_name";
        public static final String COLUMN_JOB_NUMBER = "job_number";
        */
        String query = null;
        switch(mode) {
            case MainActivity.MODE_BILLING:
                query =
                    "SELECT "+ mDbCallTable.TABLE_NAME+"."+mDbCallTable._ID+" AS android_call_id," +
                    mDbCallTable.TABLE_NAME+"."+mDbCallTable.COLUMN_PHONE+"," +
                    mDbCallTable.TABLE_NAME+"."+mDbCallTable.COLUMN_TIME+"," +
                    mDbCallTable.TABLE_NAME+"."+mDbCallTable.COLUMN_DURATION+"," +
                    mDbCallTable.TABLE_NAME+"."+mDbCallTable.COLUMN_DURATION_BILLED+"," +
                    mDbCallTable.TABLE_NAME+"."+mDbCallTable.COLUMN_PENDING+"," +
                    mDbCallTable.TABLE_NAME+"."+mDbCallTable.COLUMN_CALL_ID+"," +
                    mDbCallTable.TABLE_NAME+"."+mDbCallTable.COLUMN_JOB_ID+"," +
                    mDbCallTable.TABLE_NAME+"."+mDbCallTable.COLUMN_CUSTOMER+"," +
                    mDbJobTable.TABLE_NAME+"."+mDbJobTable._ID+" AS android_job_id," +
                    mDbJobTable.TABLE_NAME+"."+mDbJobTable.COLUMN_NAME+"," +
                    mDbJobTable.TABLE_NAME+"."+mDbJobTable.COLUMN_JOB_NUMBER+

                    " FROM " + mDbCallTable.TABLE_NAME +
                    " LEFT OUTER JOIN " + mDbPhoneTable.TABLE_NAME +
                    //" WHERE (" + mDbPhoneTable.TABLE_NAME+"."+mDbPhoneTable.COLUMN_PHONE+"='"+number_trimmed.substring(3)+"' AND LENGTH("+mDbPhoneTable.TABLE_NAME+"."+mDbPhoneTable.COLUMN_PHONE+")=7) OR (" + mDbPhoneTable.TABLE_NAME+"."+mDbPhoneTable.COLUMN_PHONE+"='"+number_trimmed+"' AND LENGTH("+mDbPhoneTable.TABLE_NAME+"."+mDbPhoneTable.COLUMN_PHONE+")=10)", null);
                    " ON '%" + mDbCallTable.TABLE_NAME+"."+mDbCallTable.COLUMN_PHONE+"' LIKE '%"+mDbPhoneTable.TABLE_NAME+"."+mDbPhoneTable.COLUMN_PHONE + "'" +
                    " LEFT OUTER JOIN "+mDbJobTable.TABLE_NAME +
                    " ON "+mDbCallTable.TABLE_NAME+"."+mDbCallTable.COLUMN_JOB_ID+"="+mDbJobTable.TABLE_NAME+"."+mDbJobTable._ID +
                    " WHERE " + mDbCallTable.TABLE_NAME+"."+mDbCallTable.COLUMN_PENDING+"=0 ORDER BY "+mDbCallTable.TABLE_NAME+"."+mDbCallTable.COLUMN_CUSTOMER+","+mDbJobTable.TABLE_NAME+"."+mDbJobTable._ID;
                break;
            case MainActivity.MODE_PENDING:
                query =
                    "SELECT "+ mDbCallTable.TABLE_NAME+"."+mDbCallTable._ID+" AS android_call_id," +
                    mDbCallTable.TABLE_NAME+"."+mDbCallTable.COLUMN_PHONE+"," +
                    mDbCallTable.TABLE_NAME+"."+mDbCallTable.COLUMN_TIME+"," +
                    mDbCallTable.TABLE_NAME+"."+mDbCallTable.COLUMN_DURATION+"," +
                    mDbCallTable.TABLE_NAME+"."+mDbCallTable.COLUMN_DURATION_BILLED+"," +
                    mDbCallTable.TABLE_NAME+"."+mDbCallTable.COLUMN_PENDING+"," +
                    mDbCallTable.TABLE_NAME+"."+mDbCallTable.COLUMN_CALL_ID+"," +
                    mDbCallTable.TABLE_NAME+"."+mDbCallTable.COLUMN_JOB_ID+"," +
                    mDbCallTable.TABLE_NAME+"."+mDbCallTable.COLUMN_CUSTOMER+"," +
                    mDbJobTable.TABLE_NAME+"."+mDbJobTable._ID+" AS android_job_id," +
                    mDbJobTable.TABLE_NAME+"."+mDbJobTable.COLUMN_NAME+"," +
                    mDbJobTable.TABLE_NAME+"."+mDbJobTable.COLUMN_JOB_NUMBER+

                    " FROM " + mDbCallTable.TABLE_NAME +
                    " LEFT OUTER JOIN " + mDbPhoneTable.TABLE_NAME +
                    " ON '" + mDbCallTable.TABLE_NAME+"."+mDbCallTable.COLUMN_PHONE+"'='"+mDbPhoneTable.TABLE_NAME+"."+mDbPhoneTable.COLUMN_PHONE + "'" +
                    " LEFT OUTER JOIN "+mDbJobTable.TABLE_NAME +
                    " ON "+mDbCallTable.TABLE_NAME+"."+mDbCallTable.COLUMN_JOB_ID+"="+mDbJobTable.TABLE_NAME+"."+mDbJobTable._ID +
                    " WHERE " + mDbCallTable.TABLE_NAME+"."+mDbCallTable.COLUMN_PENDING+"=1 ORDER BY "+mDbCallTable.TABLE_NAME+"."+mDbCallTable.COLUMN_CUSTOMER;
                break;
            default:
                break;
        }
        Message m = Message.obtain(null, MinutemaidService.MESSAGE_RAW_QUERY, MinutemaidService.QUERY_TYPE_CALL_LIST, 0, query);
        m.replyTo = this.mMessenger;
        Log.d(LOG_TAG, "query: " + query);
        try {
            msgr.send(m);
            Log.i(LOG_TAG, "MESSAGE REQEUST SENT");
        } catch(RemoteException e) {
            Log.i(LOG_TAG, "ERROR SENDING REQUEST");
            //client doesn't exist anymore?
        }
    }