[TYPO3-mvc] MM Relation with foreign tables (old exec_SELECT_mm_query())

[Claus Fassing]

Am 06.04.2012 16:33, schrieb Claus Fassing:
> It seems like that there is the operation JOIN missing.

I was looking at the sql.

SELECT tx_dam_mm_cat.* FROM tx_dam_mm_cat WHERE 
tx_dam_mm_cat.uid_foreign IN ('1','3','5','4')

Get back with 10 records and after this extbase is calling :
SELECT tx_dam.* FROM tx_dam WHERE tx_dam.uid IN ('19')

I wonder why my model settings (annotations) do not result in a JOIN.

If extbase make a second call, I rather do this by my self to get 
correct results. But I would like to know how to get extbase to join the 
tables ?

Greetz Claus