title: Retrieve columns from table A in comparsion to table B column values where there is no common relationship between two tables
body: <p>A new bird to SQL.</p>
  
  <p>Table A name is EmployeeDetails which has four columns.</p>
  
  <pre><code>EmployeeID  FirstName,  LastName,  NativeState
          1     Frank        Dyre         FL
          2     John         Smith        AL
          3     Taylor       Cox          GA
  </code></pre>
  
  <p>Table B is CompanyDetails which has three columns</p>
  
  <pre><code>CompanyID   CompanyName  HeadQuatersState
   1           Steve's       FL
   2           Johnson       NY
   3           Huston        GA
  </code></pre>
  
  <p>Now in both the tables there is no same columns. But Native State and HeadQuatersStat have common states.</p>
  
  <p>how can I retrieve first and lastname of an employee from employeeDetails table where the nativestate is not equals to company headquarters state.</p>
  
  <p>Expected result is John Smith.</p>