On 26.10.2011 7:27, Jeremy Baron wrote:
On Tue, Oct 25, 2011 at 23:23, Dmitriy Sintsovquestpc@rambler.ru wrote:
How would Sam's code guess alias for qp_users_polls ? I thought he just forgot to put the alias key 'qup' there, writing in hurry, probably.
'qu.uid=qup.uid' probably should fail in his code.
Did you miss half of what I said? I'll quote myself so you can be sure to see it this time:
I assume
array( 'qp_users_polls', 'qu' => 'qp_users' ),should instead be
array( 'qup' => 'qp_users_polls', 'qu' => 'qp_users' ),(from comment 1)
I am not native English speaker, sorry. However, in that bugreport there is second (different) query converted from MySQL string to Database::select() with arrays. It has INNER JOIN. The source query works fine, the converted one fails because table aliases are 'quoted'. Should I do not use table aliases at all? Dmitriy