Doing Inner join in SQl lite
<p>I am working in an android application and I want to work fetch details in my application local Db. The query that I am using has inner join,so its not returning values.But in the same method if I use with the query without inner join it returns value.
Please help me</p>

<pre><code>public boolean isAvailableTransitionFile(String MenuName) {

    String query = "select * from Transition_File_Table inner join item_sync on Transition_File_Table.Menuitem_id=item_sync.id where item_sync.itemName=?";
    Cursor cursor = this.db.rawQuery(query,
            new String[] { String.valueOf(MenuName) });
    Log.e("Count", cursor.getCount() + "");
    if (cursor.moveToFirst()) {
        return true;
    } else {
        return false;
    }
}
</code></pre>
