wrong id returned in join

You should define the SELECT string not using the default which is '*' ..

PHP Code:

$this->db->select('Table1.id, Table1.name1, Table2.name2'); 


Thanks, that resolves it, but kind of a pain to have to code all db fields.

You can't skip that thing. When there are 2 'id' fields its normal that you get just 1 of them. (PHP restrictions..)

I am not quite sure but if you set 

PHP Code:

$this->db->select('Table2.*, Table1.*'); 


Perhaps you will get the duplicated keys from the second set table. 
I am not quite sure if you will be allowed to do that but you  can try it.

Best VPS Hosting : Digital Ocean