does ci support relational db

[eluser]Bart v B[/eluser]
i don't understand youre question.
a relational database has nothing to do with CI or other frameworks.

You want to JOIN two table together, with active Records i gues..

Take a look in the manual
http://ellislab.com/codeigniter/user-gui...ecord.html

Code:

$this->db->select('*');
$this->db->from('blogs');
$this->db->join('comments', 'comments.id = blogs.id');

$query = $this->db->get();

// Produces:
// SELECT * FROM blogs
// JOIN comments ON comments.id = blogs.id

I would not recomend this example, but just play with it.