[TYPO3-dev] Alter foreign_table_where to select items from parent page

[Brian Bendtsen]

Peter Klein skrev:
> Hi Brian.
> Your example on what you do in mysqlFront and in TYPO3 is quite different. 
> Have you tried something like this (Untested):
> 
> "foreign_table" => "tx_ebbolig_afdeling INNER JOIN pages ON 
> tx_ebbolig_afdeling.pid = pages.pid",
> "foreign_table_where" => "AND pages.uid=###CURRENT_PID###",
> 
Hi

I have tried this, it results in this sql error:
You have an error in your SQL syntax; check the manual that corresponds 
to your MySQL server version for the right syntax to use near 'INNER 
JOIN pages ON tx_ebbolig_afdeling.pid = 
pages.pid.uid,tx_ebbolig_afdeling ' at line 1 This may indicate a table 
defined in tables.php is not existing in the database!

The documentation about this implies that the join between my table and 
the pages table is created automatically.

Therefore I have tried it without the JOIN but then nothing appears in 
the select box -> no output from sql.

If only I could print out the sql?

/BB