title: mysql Query to get data from two tables when not exists in either table
body: <p>I am trying to fetch data from 2 tables, Table A and Table B.
  Table A has id , name , description.
  Table B has name , details , sub_details.</p>
  <p>There are total 10 records in A and 5 Records in B.</p>
  <p>if I execute a query,</p>
  <pre><code>select a.id , a.name , b.details , b.sub_details 
  from A a, B b 
  where a.name = b.name and b.name like &quot;%ABC%&quot;;
  </code></pre>
  <p>the result will be show the records which has <code>ABC</code> in <code>b.name</code> column and where the same is present in A table. Now the issue occurs when any of the table does not have the data, and in that case entire result is blank.</p>
  <p>my question is , what query shall I execute if I want to get the results even if any of the table does not have the data ?</p>