Implement the JOIN feature

[edhelas]

The JOIN feature is missing

We can use such syntax

$query = Post::query()
                            ->where(array('key' => $this->user->getLogin(), 'parentid' => ''))
                            ->orderby('updated', true)
                            ->join('Attachment', array('key_src' => 'key_dest');
$messages = Post::run_query($query);

Will return a 'Post' instance with Attachment attributes.

[Etenil (etenil)]

OK I've been hacking on that one today. Doing it properly will involve some major work on the drivers.

I could make a quick fix to get the join working, but then the back-end won't be clean the drivers API won't be robust (it's already too fragile). I'll do both at the same time, that shouldn't change Datajar's existing API, just bring in the joins for you.

[edhelas (edhelas)]

Thanks for the implementation of the simple JOIN feature.
Can you implement the :
- LEFT and RIGHT OUTER JOIN
- and if you can the FULL OUTER JOIN
?