SQL join between 3 tables
Hello,
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:
1. Language - name and id.
2. phrase - name and id.
3. translation - id, translation, fk_language and fk_phrase.
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.
Thanks.
Subject
Written By
Posted
SQL join between 3 tables
October 15, 2020 05:30AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.