On Tue, Oct 25, 2011 at 23:23, Dmitriy
Sintsov<questpc(a)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