Quick question! Multiple tables

[eluser]Paleleaves[/eluser]
Hi,

I've a model. Pls see the code below

Code:

<?php
class Articles_model extends Model
{
  function Articles_model()
  {
      parent::Model();
      $this->load->database();
  }
  
function list_participants($num, $offset)
  {
      

$query = $this->db->get('property', $num, $offset);
      return $query;
  }
}
?>

It's working fine but I need pass multiple tables in the place of 'property' in my model. see the code below.

Code:

SELECT * FROM property, district, ptype WHERE property.reqType = ptype.pID AND property.districtName = district.dID

Anybody can help me to modify my model using this query. thanks