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

[Steffen Ritter]

CREATE
[OR REPLACE]
[ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}]
[DEFINER = { user | CURRENT_USER }]
[SQL SECURITY { DEFINER | INVOKER }]
VIEW view_name [(column_list)]
AS select_statement
[WITH [CASCADED | LOCAL] CHECK OPTION]

example:
CREATE VIEW v AS SELECT qty, price, qty*price AS value FROM t;

more Details and examples you will find mysql reference Manual Chapter 
21 (about Views) especially for you 21.2 (creating views)

greetings

Steffen

Brian Bendtsen schrieb:
> 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