[TYPO3-dev] TCA - type select, select from joined tables?

[Brian Bendtsen]

Steffen Ritter skrev:
> Well
> forget about this crouded way :P
> much more easy an not misusing typo3 api:
> define a view containing you joined data and define this view as a own 
> table with tca so that typo3 can access it,
> then simply set foreign_table to tx_myext_specialview
> 
> greetings
> 
> Steffen

Hi Steffen

Sounds simple, but how is the view defined, can you give me an example 
or link to one.

I thank you for your help

/Brian