Join two columns in one columns codeigniter

Question

is this possible ? two columns in one columns on table ?

$this->db->select('header.*,customer.*,destination.location');
$this->db->from(self::WAYBILL_HEADER_TABLE. " as header");
$this->db->join(self::CUSTOMER_TABLE." as customer","header.consignee = customer.id");
$this->db->join(self::WAYBILLDESTINATION_TABLE. " as destination","header.destination_from = destination.id",'INNER');

$this->db->join(self::WAYBILLDESTINATION_TABLE. " as destinations","header.destination_to = destinations.id",'INNER');
$this->db->where('header.waybilldate <=',$date_to);
$this->db->where('header.waybilldate >=',$date_from);
$this->db->order_by('header.waybillno','DESC');
$query = $this->db->get()->result();
return $query;

Are you trying to join two columns in one from the same table.row ? — The Alpha, Sep 30 '13 at 07:28
Were you thinking of a self join? http://stackoverflow.com/questions/1284441/how-does-a-mysql-self-join-work — xiankai, Sep 30 '13 at 16:50

score 0 · Answer 1 · answered Sep 30 '13 at 07:27

0

Try this

 $this->db->join('t2', 't1.x = t2.c', 'left');

answered Sep 30 '13 at 07:27

Vaibs_Cool

6,126
5
28
61

I think, `OP` wants to join/concat two columns in one from same table.row, not two tables but I could be wrong too. – The Alpha Sep 30 '13 at 07:46
1

Maybe you should provide an explanation to this code snippet. What was wrong with original code? What has changed? Why it should work? – default locale Sep 30 '13 at 07:51

score 0 · Answer 2 · edited May 23 '17 at 12:30

0

Your question is not clear but to join two columns in one you may use CONCAT function in your select statement like this

$this->db->select('table_name.column1, CONCAT(table_name.column2, ' ', table_name.column3) as table_name.twoInOne');

This is just an idea how you can use concat function. Also, for group concat check this answer.

edited May 23 '17 at 12:30

Community

1
1

answered Sep 30 '13 at 07:40

The Alpha

143,660
29
287
307

score 0 · Answer 3 · edited Aug 16 '19 at 10:20

0

try:

$this->db->query("SELECT CONCAT(column1,' ',column2) FROM employee_tbl");

This solution is described at http://www.tutorialspoint.com/mysql/mysql-concat-function.htm

edited Aug 16 '19 at 10:20

B--rian

5,578
10
38
89

answered Jan 27 '16 at 09:41

Moriya Shtern

11
2

score 0 · Answer 4 · edited Aug 16 '19 at 09:01

0

I suggest to join two or more columns in same table:

    $this->db->select("*");
    $this->db->from("follows");
    $this->db->join('users table1','table1.user_id=follows.following_id','left');
    $this->db->join('users table2','table2.user_id=follows.follower_id','left');
    $this->db->where("table1.is_active",1);
    $this->db->where("table2.is_active",1);
    $res=$this->db->get();
    return $res->result();

edited Aug 16 '19 at 09:01

B--rian

5,578
10
38
89

answered Aug 16 '19 at 07:48

Dinesh RajMi

1
1

Welcome to SO! Please edit your question and add a bit of explanation/ context, see https://stackoverflow.com/help/how-to-answer for more guidance. – B--rian Aug 16 '19 at 08:12

Join two columns in one columns codeigniter

4 Answers4