Issues with join

I have written a function that joins together two fields, the query
that gets outputted for some reason has the ' instead of the `
symbols.

The following code:

$conditions = array('Formula.formulasId' => $id);
$fields = array(
'materials.description', 'formula.formulasId, formula.materialsId,
formula.weight');
$instructions = $this->Formula->find('all',
array('conditions' => $conditions, 'fields' => $fields,
'alias' => 'formulas', 'joins' => array (
array(
'table' => 'materials',
'alias' => 'materials',
'conditions' => array('formula.materialsId' => 'materials.file'),
'type' => 'left',
'foreignKey' => 'materials.id'
),
)));

outputs this as a result:

SELECT `materials`.`description`, formulas.formulasId,
formulas.materialsId, formulas.weight FROM `formulas` left JOIN
`materials` ON (`formulas`.`materialsId` = 'materials.file') WHERE
`formulas`.`formulasId` = 2

which nulls out the materials.description field. What I need is
CakePHP to output this:

SELECT `materials`.`description`, formulas.formulasId,
formulas.materialsId, formulas.weight FROM `formulas` AS `formulas`
left JOIN `materials` AS `materials` ON (`formulas`.`materialsId` =
materials.file) WHERE `formulas`.`formulasId` = 2;

Any help is super appreciated.

--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.

To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php