dongmaijie5200 2018-01-28 20:58
浏览 276
已采纳

MySQL左外连接问题双重id [重复]

This question already has an answer here:

I'm using a left outer join in a query. but now I'm getting a double id, What I mean is that I now get the id of table 1 and the id of table2 both called id.

Is there a way to maybe rename(prefix) the id of table 2 with something like table2_id? without having to use 'AS table_nameOfColumn' for every column of table 2

My current query:

SELECT invoices.*, clients.* FROM invoices 
LEFT OUTER JOIN users ON invoices.employee_id = users.id 
LEFT OUTER JOIN clients ON users.client_id = clients.id
WHERE invoices.employee_id = 3
</div>
  • 写回答

1条回答 默认 最新

  • douw92892 2018-01-28 21:06
    关注

    you can simply add an alias to your columns name naming explicitally

    eg:

      SELECT invoices.id as invoce_id, clients.id as client_id FROM invoices 
      LEFT OUTER JOIN users ON invoices.employee_id = users.id 
      LEFT OUTER JOIN clients ON users.client_id = clients.id
      WHERE invoices.employee_id = 3
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥50 swiftui @query 报错
  • ¥50 怎么解决刷卡或扫码后,点击软件输入框,win10屏幕键盘不会自动弹出的问题
  • ¥15 如何使用arcgispro的训练深度模型,发现water和nowater精度为0?(相关搜索:深度学习)
  • ¥20 matlab作业不太懂呀有问题能给个代码吗
  • ¥15 自制电路图为何无法驱动ESP01S?
  • ¥15 前端加access数据库
  • ¥15 ARCGIS 多值提取到点 ERROR 999999
  • ¥15 mysql异常断电, [MY-011971] [InnoDB]
  • ¥15 uni.onBluetoothDeviceFound熄屏不运行
  • ¥15 求PHDA糖尿病并发症数据集,有偿