problemer med innerjoin

Jeg havde misforstået hvordan man joiner i sql

Sådan her løste jeg det :
kilde: http://www.youtube.com/watch?v=3xK5KKQx-J0

select
    foodGroups.id,
    IF (translation.name IS NULL, foodGroupsTranslations.name, translation.name) AS name
   
From foodGroups
        left join foodGroupsTranslations ON (foodGroups.id = foodGroupsTranslations.fooditemID and foodGroupsTranslations.isDefault = 1)
        left join foodGroupsTranslations as translation ON (foodGroups.id = translation.fooditemID and translation.language = "dk")