join with multiple conditions

[eluser]bretticus[/eluser]
Funny, I am using CI 1.7.1 and when I use the following line for multiple conditions on my join:

Code:

$this->db->join('ProductPhotos', '(Products.ProductID = ProductPhotos.ProductID) AND (Photos.Type = \'small\')', 'left');

I get an error because it produces this:

Code:

LEFT JOIN `ProductPhotos` ON `Products`.`ProductID` = `ProductPhotos`.`ProductID)` AND (Photos.Type = 'small')

It is automatically whacking off the first parenthesis.

Anybody have a similar problem?