title: Getting values back from two columns from two different tables
body: <p>I am trying to figure out a query where it will list every row in a specific column the associated data  in another column:</p>
  
  <p><img src="https://i.stack.imgur.com/fm4PI.png" alt="enter image description here"></p>
  
  <p>So I want every value in the name column and a column next to it from another table. The value 44 below is a primary key, so if there is a value in that column I want to get the name of a column from another table who's primary key it belongs. If it is void I want nothing or void to be returned.</p>
  
  <p>If I do:</p>
  
  <pre><code>SELECT [Theme].[Name], [ThemeType].[Type] 
  FROM [Theme], [ThemeType] 
  WHERE [Theme].[ThemeTypeId] = [ThemeType].[PK_ThemeType]
  </code></pre>
  
  <p>it is only returning the values where both exist. How can I get both back?</p>