title: Join two tables with no link - i.e. primary key in SQL Server Management Studio
body: <p>I would like to know how to query two tables with no primary key link. The tables are from the same database and I need to match treenotediscription to employeeid so the results come back true at the moment I'm getting a lot of duplicate and untrue values, I think this is because of no link. Any help would be appreciated.</p>
  
  <pre><code>SELECT DISTINCT 
      EMPLOYEE.EMPLOYEECODE, 
      TREENODEDESCRIPTION.TREENODEDESCRIPTION2
  FROM         
      EMPLOYEE 
  CROSS JOIN
      TREENODEDESCRIPTION
  ORDER BY 
      EMPLOYEE.EMPLOYEECODE
  </code></pre>