[TYPO3-mvc] JOIN

[Christian Tauscher]

Am 19.05.2015 um 11:07 schrieb bernd wilke:

 > you have only one mm_record in your join, this record can not point to
 > 'farbe' and to 'deutschland' at the same time
 >
 > so you need a double join:
 >
 > SELECT DISTINCT uid, company FROM tt_address
 > INNER JOIN tt_address_group_mm as mm1 ON tt_address.uid = mm1.uid_local
 >           , tt_address_group_mm as mm2 ON tt_address.uid = mm2.uid_local
 > WHERE mm1.uid_foreign == 'deutschland'
 >    AND mm2.uid_foreign == 'farbe'


Oh ja. Thank you.

Is there a extbase-SQL-option to stet to perform this "real AND" or do I 
have to do this on my own (not the problem).


Thank you for opening my eyes,

Chrstian.