如何解决SQL中FROM的语法错误?

Question

我做了如下查询:

SELECT cust_number, cust_name, COUNT(ord_number) AS number_of_orders,
FROM MSC_Customer, MSC_Order
WHERE MSC_Customer.cust_number = MSC_Order.cust_number
GROUP BY cust_number

这会产生以下错误:

Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'FROM'
Completion time: 2021-10-20T19:34:43.8096950-04:00

我不知道如何修复这个错误。

输入图片描述

一个select语句，显示客户号、客户名和属于该客户的订单数。两个表需要连接

Answer 1

你需要去掉FROM前面的逗号。