title: SQL join between 3 tables with empty rows
body: <p>I need to save language translations for phrases. I have created 3 tables, one for phrases, one for languages and one for translations with the following details:</p>
  <ol>
  <li>Language - name and id.</li>
  <li>phrase - name and id.</li>
  <li>translation - id, translation, fk_language and fk_phrase.</li>
  </ol>
  <p>How do I create a query when I get all the phrases that exist, as well as all the translations for a particular language. If there are no translations, I still want all the phrases to be there.
  The web page has a dropdown to select a language, and then enter the translation for all the phrases and then save all the translations with one save button.</p>
  <p>Thanks.</p>