title: How to create specification using JpaSpecificationExecutor by combining tables?
body: <p>I am using <code>JpaSpecificationExecutor</code> for creating custom queries. How do I create a Specification for the following SQL?</p>
  <pre><code>select * from employee e, address a where e.id=23415 and e.name=&quot;Foo&quot; and a.city=&quot;London&quot;;
  </code></pre>
  <p>Java Class :</p>
  <pre><code>public static Specification&lt;Employee&gt; searchEmployee(final Map&lt;String,String&gt; myMap) {
      
      return new Specification&lt;Employee&gt;(){
          @Override
          public Predicate toPredicate(Root&lt;Employee&gt; root, CriteriaQuery&lt;?&gt; query, CriteriaBuilder cb) {
                 
               //Need to query two tables Employee and Address  
               
             }
        }
  </code></pre>