数据表表名别名、字段别名问题

Created 7 years ago by qqwa222j, Updated 7 years ago Revision #1 5897 views 0 likes 0 collects

image http://forum.laravelacademy.org/assets/images/268-NODKV2nsopBJ2lX1.png

image http://forum.laravelacademy.org/assets/images/268-ZRykvKvbtQ2qiFxL.png

如图所示，多表查询，数据表别名如何写？

Vote Vote Cancel

Collect Collect Cancel

因为设置了表前缀，所以别名后也自动添加了表前缀，所以在字段的地方需要加上表前缀，字段别名使用DB::raw处理一下