[RESOLVED] Inner Join order by Fails

[moboter]

$result=mysql_query("SELECT\n"
    . "$datenbankname$jahr.id,\n"
    . "$datenbankname$jahr.ELEKTRO,\n"
    . "$datenbankname$jahr.Datum,\n"
    . "$datenbankname$jahr.dID,\n"
    . "$datenbankname$jahr.kuerzel,\n"
    . "$datenbankname$jahr.Summe,\n"
    . "$datenbankname$jahr.gruppe,\n"
    . "friends.KD_Name as name\n"
    . "FROM\n"
    . "$datenbankname$jahr\n"
    . "Inner Join friends ON $datenbankname$jahr.dID = friends.dID order by $datenbankname$jahr.$orderby $reihenfolge");

Running this query it produces a result (the result I expect) however if I get to the order by bit it fails with

"Unknown column 'outgoings2010.name ' in 'order clause'string(25) "outgoings" int(2010) string(4) "name" string(4) "desc" 

I know that that colum isnt in that specific table but I thought it would keep the query data
I call the page

<a href=\"$filename?orderby=name&amp;reihenfolge=desc\">
                        <img src=\"./images/absteigend.gif\" alt=\"absteigend\" title=\"absteigend\" style=\"border:none;\"></a>
                        Name
                        <a href=\"$filename?orderby=name&amp;reihenfolge=asc\">
                        <img src=\"./images/aufsteigend.gif\" alt=\"aufsteigend\" title=\"aufsteigend\" style=\"border:none;\"></a>

what am I missing?
Its is only on this one field which isnt native to the table.

[moboter]

Sorry folks I was just to blind to see