[FLOW3-general] joins in select queries with TypoScript

[Robert Wildling]

THanks for the hint, it is a typo here in the mail - sorry for that: The 
correct spelling is as follows:

select.join = tx_buzzwords ON (tt_content.tx_buzzwords_buzzword = 
tx_buzzwords.uid)

Nevertheless - everything afterwards doesn't generate anymore...


I'd be happy for any further tipps!
Thanks!


> Hi,
>
> On 2-5-2012 11:05, Robert Wildling wrote:
>> Say, do you happen to know out of the blue whether join-statements work
>> within renderobj-CONTENT elements? Because this doesn't work at all:
>
> renderObj can be any cObject. This includes CONTENT.
>
>> table = tt_content
>> select {
>> pidInList.field = uid
>> selectFields = *
>> andWhere = colPos = 1
>> orderBy = sorting
>> }
>> select.join = tx_buzzwords_word ON (tt_content.tx_buzzwords_buzzword =
>> tx_buzzwords.uid)
>
> You JOIN with the table tx_buzzwords_word and use the table tx_buzzwords
> in the ON() part...
> I guess it will just fail with an SQL error "Unknown table tx_buzzwords"
>