How to convert from Mysql query to Codeigniter syntax?

[eluser]Thorpe Obazee[/eluser]
[quote author="Phil Sturgeon" date="1245246172"]Why do a GROUP BY just to get a count in? This should do the same thing.

Code:

$this->db->join('lib_books', 'lib_books.boo_id = lib_borrowings.boo_id', 'inner');
$count=$this->db->count_all_results('lib_borrowings');
echo $count;

[/quote]

I believe he was trying to get some more information than but in the end, he actually didn't.