Query a duplicate data from two different tables <p>I have two tables on DBA.</p> <pre><code>Table1: name_id | id | lastupdated | name Table2: user_id | action_view | mob_no | process | result </code></pre> <p>These two tables are related with name_id=user_id.</p> <p>I want to query all the users, that have the same mobile number for whom column <code>result</code> is 1 (meaning successful).</p> <p>Lets say for Name(John in Table1) we have 3 different mobile numbers in table 2 and for each the <code>result</code> is 1.</p>