duanouyong4228 2016-10-27 05:29
浏览 32

如何在Laravel Query Builder中使用“USING”

I'm wondering if it's possible to use LEFT JOIN table USING (id) ... anyone who tried using "USING" in laravel query builder?

Normally, a MySQL query statement "SELECT * FROM t1 LEFT JOIN t2 ON (t1.id = t2.id)" can be written in Laravel Query Builder like below...

DB::table('t1')->leftJoin('t2','t1.id','=','t2.id')->get();

But, how do you write this "SELECT * FROM t1 LEFT JOIN t2 USING (id)" in Laravel Query Builder?????

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 C++ yoloV5改写遇到的问题
    • ¥20 win11修改中文用户名路径
    • ¥15 win2012磁盘空间不足,c盘正常,d盘无法写入
    • ¥15 用土力学知识进行土坡稳定性分析与挡土墙设计
    • ¥70 PlayWright在Java上连接CDP关联本地Chrome启动失败,貌似是Windows端口转发问题
    • ¥15 帮我写一个c++工程
    • ¥30 Eclipse官网打不开,官网首页进不去,显示无法访问此页面,求解决方法
    • ¥15 关于smbclient 库的使用
    • ¥15 微信小程序协议怎么写
    • ¥15 c语言怎么用printf(“\b \b”)与getch()实现黑框里写入与删除?