title: SQL Query with multiple tables to fetch data from one table and populate in another
body: <p>I have two tables <code>A</code> and <code>B</code>. Table A has the columns as <code>PersonID</code>, <code>MobileNumber</code>, <code>PersonName</code> where <code>PersonID</code> and <code>MobileNumber</code> are unique columns. Table B has he columns as <code>ReportID</code>, <code>PersonID</code>, <code>Details</code> with <code>ReportID</code> as unique column.</p>
  
  <p>Each person can add any number of Reports with different <code>ReportID</code>. Now my Table B has many reports and I want to add the <code>MobileNumber</code> column to it. But Table B has many entries for a single person. What query can I use to take the <code>MobileNumber</code> from Table A and populate it to Table B with respect to each <code>PersonID</code>? The query should take <code>MobileNumber</code> from Table A and then add it to Table B across the <code>PersonID</code> column.</p>
  
  <p><strong>EXAMPLE</strong></p>
  
  <p><strong>Table A</strong></p>
  
  <pre><code>PersonID   |   MobileNumber   |   PersonName
     P1           9999999999           John
     P2           8888888888           Mack
     P3           7777777777           Jack
     P4           6666666666           Mike
  </code></pre>
  
  <p><strong>Table B</strong></p>
  
  <pre><code>ReportID   |   PersonID   |   Details   |   MobileNumber
     R1             P1           .....
     R2             P2           .....
     R3             P2           .....
     R4             P3           .....
     R5             P3           .....
     R6             P3           .....
     R7             P4           .....
     R8             P4           .....
  </code></pre>
  
  <p>What is the query I can use to populate mobile number and get the result as below?</p>
  
  <p><strong>EXPECTED RESULT</strong></p>
  
  <pre><code>ReportID   |   PersonID   |   Details   |   MobileNumber
     R1             P1           .....         9999999999
     R2             P2           .....         8888888888
     R3             P2           .....         8888888888
     R4             P3           .....         7777777777
     R5             P3           .....         7777777777
     R6             P3           .....         7777777777
     R7             P4           .....         6666666666
     R8             P4           .....         6666666666
  </code></pre>
  
  <p>PS:<br>
  I don't want to select the values as new table. I want to populate the values in the original table itself using UPDATE</p>