Hello i want to join three tables but it fetch all data from user table, i just want firstname and lastname parameter in that
Here is my join query. i want something like join(user.firstname).
$this->db->select('*');
$this->db->from('post');
$this->db->join('user', 'user.id = post.cop_id');
$this->db->join('source', 'post.source_id = source.id');
$query = $this->db->get();
return $query->result();
你好我想加入三个表但它从用户表中获取所有数据，我只想要firstname和lastname参数
这是我的连接查询。 我想要一些像join（user.firstname）。
$ this-＆gt; db-＆gt; select（'*'）;
$ this-＆gt; db- ＆gt; from（'post'）;
$ this-＆gt; db-＆gt; join（'user'，'user.id = post.cop_id'）;
$ this-＆gt; db-＆gt; join（ 'source'，'post.source_id = source.id'）;
$ query = $ this-＆gt; db-＆gt; get（）;
return $ query-＆gt; result（）;
微信扫一扫
