Can I get an example of how to do a Join with Query Binding?

[eluser]slaytorson[/eluser]
Can I get an example of how to do a Join with Query Binding?

I will be using multiple joins.

I can seem to get the join working with my query bind.

[eluser]theprodigy[/eluser]
are you trying to bind the join, or just bind with a query that has a join?

[eluser]slaytorson[/eluser]
A query that has a join.

[eluser]theprodigy[/eluser]

Code:

$sql = "SELECT * FROM some_table st JOIN some_other_table sot on st.sot_id = sot.id WHERE id = ? AND status = ? AND author = ?";

$this->db->query($sql, array(3, 'live', 'Rick'));

Like that?