mysql - 用于内部连接的 laravel 查询构建

Question

如何为以下 mysql 查询构建查询？

SELECT routes.id, src.title, dest.title, groups.title FROM routes INNER JOIN locations as src ON (src.id = routes.src) INNER JOIN locations as dest ON (dest.id = routes.dest) INNER JOIN groups ON (groups.id = routes.groups) order by routes.id

标签： mysqllaravel

Answer 1

我不知道 src.title 和 dest.title 之间的区别，但这个查询会帮助你。

 DB::table('routes')->select('routes.id','src.title', 'groups.title')->join('locations as src', 'routes.src', '=', 'src.id')->join('groups', 'routes.groups', '=', 'groups.id')->orderBy('routes.id','DESC')->get();