I store translations in a table. I would like to find out every record for which I have a translation. The records differ only in their language code column. The other primary keys are all the same. I would also like to find out for which I have no translation yet.

**Example records**:

```
Id  SudId   LanguageCode    Caption
1   0       en-us           hello
1   0       fr-fr           bonjour
2   1       en-us           how are you?
2   1       fr-fr           comment allez-vous?
3   0       en-us           how is the weather?

```

In the first step I would expect only the first and the third dataset, because I have a translation for this one.

```
Id  SudId   LanguageCode    Caption
1   0       en-us           hello
2   1       en-us           how are you?

```

Then I would like to find all for which there is no translation. Here I expect the last record.

```
Id  SudId   LanguageCode    Caption
3   0       en-us           how is the weather?

```