Join Operation

[eluser]Suhas nazir[/eluser]
Can u please tell how we write join operation if the 2 tables contain same field how i differentiate these 2 fields.. please help????

[eluser]nelson.wells[/eluser]
You need the AS clause in your JOIN. Do some Google-ing (I'll get you started).

[eluser]flaky[/eluser]

Code:

$this->db->select('post_id');
$this->db->from('post');
$this->db->join('user', 'post.user_id = user.user_id');