How to return mutiple records from a JOIN as columns?
===

I have the following SQL statement which is joining two tables, the results are that I have a record per day with totals for the day, but joining it to the language table, it gives me **five records per day**, one for each language.

    SELECT 
    re.day,
    re.flashcardsAdded,
    re.flashcardsTested,
    re.flashcardsLearned,
    re.totalPoints AS totalForDay,
    la.language,
    la.total AS totalForLanguage
    
    FROM dpod_site_reportDays AS re
    JOIN dpod_site_reportDayLanguageTotals AS la ON re.day=la.day
    ORDER BY re.day DESC

However, **I want only one record per day** and instead of e.g. "french" being data, I want it to be a column name with the total for that language as the data for that column.

How can I change the SQL statement so that I get the language totals in the same record with appropriate field names, e.g.:

    day | flashcardsAdded | flashcardsTested | flashcardsLearned | totalForDay | french | german | italian | russian | german


![enter image description here][1]


  [1]: http://i.stack.imgur.com/LtRwn.jpg