How to join two tables in sqlite android?
<p>Am having a two tables one is travel and another one is call in this two table i have one common field incident id based on that id need to fetch two table value how can i do that.  Now let me explain my problem in detail </p>

<p>Here is my travel table:</p>

<pre><code>ID  INCIDENT_ID Lat  Long   Time
--  ----------- ---  ----   -----
1     2         13.2 13.5   13456 
</code></pre>

<p>Here is my Call Table:</p>

<pre><code>ID  INCIDENT_ID  DESC   START    END 
--  -----------  ----   -----    ---
1       2         test   23      33
</code></pre>

<p>Now how to join these two table so far what i have tried is query :</p>

<pre><code>  String visitquery = "SELECT   " +  VisitModel.INCIDENT_ID + ","  +  VisitModel.DESC +  " ,"  + VisitModel.Visit_START + " ," + VisitModel.Visit_END  + " , "+ VisitModel.Visit_TRAVELAT  +  " , " +  VisitModel.Visit_TRAVEL_LONG + " FROM " + VisitModel.CALL_TABLE + " LEFT OUTTER JOIN " + VisitModel.Visit_TravelTable
                + " ON " + VisitModel.Visit_IncidentID  + " = " + VisitModel.Visit_TravelIncidentID
                + " WHERE " + VisitModel.Visit_IncidentID + " = " +  id;
</code></pre>

<p>Am not getting results from travel table how to achieve this is there any other way.</p>