I have a main table that has a 0:N relationship with another table. I (well really not me, but the puzzle intrigued me) want to present the first two (in reality five) results of the other table as columns of the main table. The other table can contain 0 to N rows.
Main:
id,name
1,one
2,two...