[FLOW3-general] joins in select queries with TypoScript

[Robert Wildling]

Found the mistake: debugging told me that the "select" statement in 
"orderBy" is ambigious. This works:

...
orderBy = tt_content.sorting
...

Thanks you very much for your help and patience!!!

Have a nice day!
Robert


> 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"
>>
>