title: SQL lookup and reference table definitions
body: <p>I need some clarification. What is a lookup table and what is a reference table in SQL?</p>
  
  <p>I was under the impression that a lookup table is a table that has static data that hardly ever changes (e.g. a table that has all 50 states and their capitals) and a reference table is one that contains primary keys and links two other tables. In the example below, Table B would be a reference table. Can someone tell me what Table B is called?</p>
  
  <pre><code>Table A
  CustomerID
  CustomerName
  CustomerAddress
  
  Table B
  CustomerID
  OrderID
  
  Table C
  OrderID
  OrderDate
  </code></pre>