How can i write join query in android sqlite?
<p>Hi, I am new to android. I want to write query for join in sqlite. My code is - </p>

<pre><code>public Cursor SearchCategory(SQLiteDatabase db){
        //return  db.query("category_master", null, "status = 'Active'", null, null, null, null);

        String Category_Sql = " select category_master.*,count(*) as cnt from product_master " +
                            "   left join category_master on product_master.category_id = category_master.category_id " +
                            "   where category_master.status = 'Active' group by category_master.category_id having cnt &gt; 0 ";
        return db.query(Category_Sql);
    }
</code></pre>

<p>but it generate error. Where am I wrong?</p>
