title: Joining two SQL Tables with no relationship?
body: <p>I have 2 tables in a MySQL database. One is a legacy table (landlords) which has a field ('landlord_id').</p>
  
  <p>The other is a Joomla! 1.7 table called jos_users which is needed to ensure all users are valid Joomla! users and can login, etc. It has a field called 'id'.</p>
  
  <p>As an example I have an existing record in landlords.landlord_id = 2 (John Smith), however there is no corresponding jos_user.id record because the landlords table pre existed before the jos_users.</p>
  
  <p>Is there a way to establish / create a relationship between the two using SQL?</p>
  
  <p>Or</p>
  
  <p>Do I need to create jos_user records for the landlords (and if so how?)?</p>
  
  <p>Any suggestions or examples are greatly appreciated.</p>