dousheng3364 2015-12-02 15:21
浏览 32
已采纳

在codeigniter中将两列连接到一列

I have been searching and still feel lost.

My sql DB is like this
bf_putnr -> colums: PUTNR_ID|PUTNR
Data:
PUTNR_ID PUTNR
1 put_1
2 put_2
3 put_12
4 put_28
5 put_34

bf_rioo -> colums: RIOO_ID|PUTA|PUTB
RIOO_ID PUTA PUTB
1 put_1 put_2
2 put_1 put_28
3 put_12 put_1


PUTA and PUTB are the same as PUTNR in the table bf_putnr

in codeigniter i'd like to get the PUTNR_ID when getting all the bf_rioo data

This is what i came up with,

                $this->db->from('bf_rioo');

                $this->db->join('bf_putnr AS A', 'bf_rioo.PUTA = A.putnr');
                $this->db->join('bf_putnr AS B', 'bf_rioo.PUTB = B.putnr');

but it only returns the second join. I think the second join is overwriting the data from the first one. I get all colums from bf_rioo and all columns from bf_putnr but only joined on the last join statement.....?

How do i get the join on putnr to return the data for PUTA and PUTB ??

  • 写回答

1条回答 默认 最新

  • duandang2123 2015-12-02 15:47
    关注

    You can use both join conditions in the same join statements.

    $this->db->from('bf_rioo');
    $this->db->join('bf_putnr AS A', 'bf_rioo.PUTA = A.putnr AND bf_rioo.PUTB = A.putnr);
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 DB-GPT-HUB Text-to-SQL微调
  • ¥20 求解答(matlab)
  • ¥30 ffmpeg库使用过程中遇到的问题
  • ¥15 pyqt5 中python如何通过Qtwebchannel主动发消息给web前端
  • ¥15 关于HTML中title获取xml内容的问题
  • ¥15 fanuc机器人PRIO083数字信号未复原错误,如何解决?
  • ¥20 如何为现有电路板增加远程控制功能
  • ¥15 C#点击按钮的时候的循环次数就是最后一次,如何是循环第几次的值?
  • ¥15 UE5打包失败,求解决
  • ¥15 请问STM32G431的CANOPEN协议函数怎么写