Question about join

[kamov]

Hi,
when we have join with extra condition like this below:

echo $db->from('user')
->join('role', array('role.id' => 'user.id', 'role.id' => 10))
->select()
->sql();

Then we are passing an array with the same index "role.id".

How to handle this ?

Thanks!

[mikecao]

That is currently not supported.

[kamov]

can we do this using string like you suggest on other post ?
something like:

->join('role', 'ON role.id = user.id AND role.id = 100')

[kamov]

Maybe you could add a generic executeRawQuery() for complex query.

[mikecao]

You can already run raw queries:

$posts = $db->sql('SELECT * FROM posts')->many();

[kamov]

Oh perfect, thanks!

[kamov]

Forgot, this will also work:

->join('role', 'ON role.id = user.id AND role.id = 100') ?