I have two tables, that need to be joined.
They look like this

![enter image description here](https://i.stack.imgur.com/cewOL.jpg)

![enter image description here](https://i.stack.imgur.com/HBoV9.jpg)

I need to join them so I have all the data from both tables and then display the information like this - IF there is German translation, display ONLY German. If there is no German, display English (Which is available for all the objects)