public function testSelectJoinDifferentColumns()
{
$s = new Sql(Db::factory('Sqlite', array('database' => __DIR__ . '/../tmp/test.sqlite')), 'users');
$s->select()->join('user_data', array('id', 'user_id'), 'LEFT JOIN');
$this->assertEquals('SELECT * FROM "users" LEFT JOIN "user_data" ON "users"."id" = "user_data"."user_id"', $s->render(true));
}