I have this 2 tables

```
 Items
 ID     Type     ClientID
 ========================
 1      0        123
 2      0        123

 Texts
 ItemID   Language     Text
 ================================
 1        Eng          Hi there!
 1        Spa          Holla!
 2        Eng          bye!
 2        Spa          bye in Spanish!

```

In my final result I wat the SQL to return me this table

```
 ID      Type    Eng           Spa
 ================================
 1       0        Hi there!     Holla!
 2       0         Bye!          bye in Spanish!

```

I tried to create this statement:

```
 SELECT DISTINCT I.ID ,I.Type,
 (SELECT T.Text WHERE D.Language='Eng') AS 'Eng',
 (SELECT T.Text WHERE D.Language='Spa') AS 'Spa'
 FROM Items I
 INNER JOIN Texts T ON I.ID=T.ItemID

```

but i get this result:

```
 ID      Type    Eng           Spa
 ================================
 1       0        Hi there!     NULL
 1       0        NULL          Holla!
 2       0        Bye!          NULL
 2       0        NULL          bye in Spanish!

```