sql multiple output with JOIN

0

Hello, i have a problem displaying the query result
I would like this inquiry:

SELECT d.id,  d.name, d.birthDate,  l.pl_content,  l.en_content, l.variable FROM table1 d JOIN language l ON  l.element_id = d.id AND l.element_type = d.type ORDER BY d.birthDate DESC

The problem is, he gets the result of this query on two lines (img 1), but he needs them on one line (img2).

Now output:

https://imgur.com/wsSXPDD

i need:

https://imgur.com/lq5v8Mi

0

Why English?

0

google + crosstab or google + pivot

1 użytkowników online, w tym zalogowanych: 0, gości: 1