Hi, i'm trying to do something like:
$data=FisrtTableQuery::create()
->join('SecondTable')
->where('FirstTable.Column = SecondTable.Column')
->find();
The correct condition after parsing the query should be an equivalent of:
"SELECT * FROM first_table JOIN second_table ON
second_table.first_pk=first_table.first_pk WHERE first_table.column =
second_table.column"
but for the WHERE condition i'm getting:
"FirstTable.Column = second_table.column"
if i invert the order of the columns i get:
"second_table.column = FirstTable.Column"
So it's always the column from the table of the Query Object which never
gets parsed.
Any tips on how i might accomplish this?
thanks.
