在Codeigniter中使用JOIN时，从特定表中回显记录

Question

I have tried googling but couldn't get any information to echo a record from specific table while I generate the query using JOIN.

Here's my code:

SELECT * FROM tbl1 INNER JOIN tbl2 ON tbl1.id = tbl2.id

I want to get the id from tbl1. When I used,

echo $row->id

It does echo the id column from tbl2. What should I do to get the record from the table which I want? Thanks!

Answer 1

You need to use alias because in both tables you have same column name id, so you can use like that:

SELECT tbl1.id as id1,tbl2.id as id2 
FROM tbl1 
INNER JOIN tbl2 ON tbl1.id = tbl2.id

And:

echo $row->id1 // for table 1
echo $row->id2 // for table 2