[RESOLVED] joining 2 rows

[qrt123]

I have a small table which looks like this

id
text
language1
language2

I wan't to have an output like this: language1 and language2 combined in one row, sorted alphabetial viewed next to the text row.

Does this make sense?
How do I do this?

Sincerely
qrt123

[discostudio]

SELECT CONCAT_WS(' ', `language1`,`language2`) AS `language` FROM table

There are other ways but that's the way I do it.

[qrt123]

Thanks for your reply Discostudio.

Can't get it to work though.
I need to combine language1 and language 2 in one new temporary row, sorted in alphabetical order, and show it together wdith the row text.

Now what i'm aiming at?

Sincerely
qrt123

[discostudio]

SELECT *, CONCAT_WS(' ', `language1`,`language2`) AS `language` FROM table ORDER BY `lagnuage` ASC 

Try that, it also selects the other columns and combines both language1 & language 2 with a SPACE in between them as a column called 'language'

[qrt123]

wow

Thanks alot discostudio. Saved my day!