[TYPO3-dev] sql order by with left join

[Bas van der Togt]

Martin Kutschker wrote:
> Bas van der Togt schrieb:
>> Hello list,
>>
>> I'm trying to order a list in my extension but i can't get it work.
>> The sql has a 'left join' and that must me the problem i think.
> 
> What is the problem?
> 
>> Does anybody knows how to order my sql with a left join?
> 
> Nothing special. Your results should be sorted by th "sorting" column of 
> tx_profalsosee_cat_mm.
> 
> Masi

Nope, that's not working and i don't know why...