passing multiple table value by a single function

[eluser]Paleleaves[/eluser]
Hi,

Thank you very much for the all ..

But again stuck on a problem here.

Code:

$sql['query']= $this->db->query('SELECT * FROM property, ptype WHERE property.reqType = ptype.pID');

I managed to get the information from multiple tables using the above code but need to take the data from a third table along with this. Here is the code I tried but didn't work

Code:

$sql['query']= $this->db->query('SELECT * FROM property, ptype WHERE property.reqType = ptype.pID, district WHERE property.districtName = district.dID');

Any help will really appreciated!