php - SQL join column within 1 table -

im busy script display transactions.

i want write sql query sets on 1 line.

here sql :

select transactienummer, code gb_kaarten  order transactienummer desc limit 4 

this output :

transactienummer code 43141            1600 43141            4410 43141            1513 43141            1514 

i want have line looks :

transactienummer code 43141            1600        4410         1513         1514 

i have tried joins, dont seem it.

thanks in forehand help

i assume using mysql, should this:

select transactienummer, group_concat(string separator ' ')  gb_kaarten group code; 

pay attention have result in 1 field separated ''