[TYPO3-core] RFC: Fix for bug #1649

[Martin Kutschker]

Karsten Dambekalns <karsten at typo3.org> writes on 
Thu, 22 Dec 2005 15:09:39 +0100 (MET):

> Hi Martin.
> 
> On Thursday 22 December 2005 11:46, Martin Kutschker wrote:
> 
> > Anyway, if you have a self-referecingn relation you still have to
> > have a
> > "2nd" table. So that the statemen mentioned above makes sense. But
> > you have to use SQL aliases.
> 
> The tx_something is there, without duplicate. No need for an alias. It
> could be used, but then you would run into the risk of using an alias
> that indeed already exists in the DB. Humpf. This way has no
> associated risk.


Franz explained why you need an alias.

I suggested using "_join" as a suffix but simpy use uniqid() to avoid any risk of using an actual table name.

Masi