[Typo3-dev] t3lib_befunc::deleteClause

[Daniel Pötzinger]

Michael Stucki wrote:
> Ingmar Schlecht wrote:
> 
> 
>>Martin Kutschker wrote:
>>
>>>Reason: my Mysql 4.0 doesn't like the real tablename when I uses aliases.
>>
>>Just don't use aliases! ;-)
>>
>>Otherwise they should be implemented EVERYWHERE, for example in
>>tslib_cObj::enableFields() and many more places.
>>But I wouldn't got for that, because aliases might even become a problem
>>for DBAL.
> 
> 
> ACK! I never used aliases yet. Why not use variables in PHP instead?
> 
> - michael
Sometimes Alias are the only way to get an expected result, example 
joins beetween the same table. Something like that (find peoples with 
same name)

select DISTINCT a.name from user as a, user as b where a.name=b.name AND 
a.uid<>b.uid

Aliases are SQL-standard I guess other DBs work with it too.


Greetings