may be this might help you:-
$result = $this->LibraryItem->find('all',array('joins'=>array(
array(
'table'=>'issue_library_items',
'alias'=>'IssueLibraryItem',
'conditions'=>array('IssueLibraryItem.library_item_id=LibraryItem.id')
)),
'fields'=>array('LibraryItem.id','LibraryItem.title'),'conditions'=>array('LibraryItem
is NOT NULL',
'IssueLibraryItem.return_date is null')));
--
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=.
