[eluser]sneakyimp[/eluser]
So I'm trying to construct a join and it looks like db->join doesn't support table aliasing, which is a hassle in my case because
a) my table names happen to be really long
b) i'm defining them in class constants
The latter point results in really awkward join syntax like this:
Code:
$db->join(self::DATABASE_TABLE, OtherClass::DATABASE_TABLE" . ".id=" . self::DATABASE_TABLE . ".id");
I mean it's not hugely awkward but I find it surprising that one must explicitly type the name of a database table in the join condition because this makes one's code break if the db table name gets changed. Also, why no table aliasing? Weird.
