[TYPO3-dev] sql order by with left join

[Martin Kutschker]

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