title: SQL Join -Always return data from first table for each row in the second table
body: <p>I have two tables tblSettingsLookup and tblFirm.
  I have 5 settings in the lookuptable,which is basically used to reneder setting names dynamically. E.g. If there are 5 settings then each firm can see five settings on some page.If I add a new setting ,now all firms would see 6 settings.</p>
  
  <p>I have a page that gets all settings from the tblSettingsLookup and user can select these settings from a web page in my application via checkboxes and save it int the database.
  These user settings  are saved in another table tblusersettingsforfirms</p>
  
  <p>tblusersettingsforfirm has settingIDFK,firmIDFK,and some other columns
  tblSettingsLookup has settingID,setting name
  tblFirm  has FirmID</p>
  
  <p>What I actually need to do is that I want one query that returns all records from tblSettingsLookup and all user settings for firm based on firmID.</p>
  
  <p>I have tried left outer joins but no hope.I dont need cross joins</p>
  
  <p>The result should be something as follows:</p>
  
  <pre><code>firmid settingname      
  1      add user
  1      delete user
  1      save user
  2      add user
  2      save user
  2      delete user 
  </code></pre>