[FLOW3-general] joins in select queries with TypoScript

[Jigal van Hemert]

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"

-- 
Jigal van Hemert
TYPO3 Core Team member

TYPO3 .... inspiring people to share!
Get involved: typo3.org