Discuss / SQL / 有问题
Back

有问题

Topic source

育标66

#1 Created at ... [Delete] [Delete and Lock User]

select s.id,s.name,s.score,d.name from students s,classes d where s.class_id=d.id

为什么s.name 没有显示出来

用户6356419854

#2 Created at ... [Delete] [Delete and Lock User]

你这SQL都是错的

小甜甜郑林200

#3 Created at ... [Delete] [Delete and Lock User]

汗！~~你这语法都跟谁学的。。。

我有一台飞行器

#4 Created at ... [Delete] [Delete and Lock User]

这语句是对的啊！难道有修改？？

昵称不火

#5 Created at ... [Delete] [Delete and Lock User]

有两个name字段，后一个把前一个覆盖了，你可以另起个名，比如select s.id,s.name AS sname,s.score,d.name AS dname from students s,classes d where s.class_id=d.id就可以了

  • 1

Reply