asp.net中的sql问题

在asp.net（c#）创建数据访问层编程中，在配置select语句时提示在from附近的where子句出错，无法生成分析查询文本。sql代码如下：

SELECt ProductID, ProductName, EnglishName,SupplierID, CategoryID, QuantityPerUnit, UnitPrice, UnitsInStock, UnitsOnOrder, ReorderLevel, Discontinued,
(SELECT CategoryName
FROM Categories
WHERe Categories.CategoryID = Products.CategoryID) AS CategoryName,
(SELECt CompanyName
FROM Suppliers
WHERe Suppliers.SupplierID = Products.SupplierID) AS SupplierName,
FROM Products

本人还是新手，看不出问题，麻烦各位高手指教了，谢谢！

试下用连接看行不....

SELECt P.ProductID, P.ProductName, P.EnglishName,P.SupplierID, P.CategoryID, P.QuantityPerUnit, P.UnitPrice, P.UnitsInStock, P.UnitsOnOrder, P.ReorderLevel, Discontinued, C.CategoryName,S.SupplierName
FROM Products P INNER JOIN Categories C ON P.CategoryID=C.CategoryID
inner join Suppliers S ON P.SupplierID=S.SupplierID

最后的 AS SupplierName, 去掉逗号。

SELECt ProductID, ProductName, EnglishName,SupplierID, CategoryID, QuantityPerUnit, UnitPrice, UnitsInStock, UnitsOnOrder, ReorderLevel, Discontinued, (SELECT CategoryName FROM Categories WHERe Categories.CategoryID = Products.CategoryID) AS CategoryName, (SELECt CompanyName FROM Suppliers WHERe Suppliers.SupplierID = Products.SupplierID) AS SupplierName FROM Products

好像 Select 语句中不能再用Select 嵌套的。只能放在From, where中。

SELECt ProductID, ProductName, EnglishName,SupplierID, CategoryID, QuantityPerUnit, UnitPrice, UnitsInStock, UnitsOnOrder, ReorderLevel, Discontinued from Products inner join Categories on Categories.CategoryID = Products.CategoryID inner join Suppliers on Suppliers.SupplierID = Products.SupplierID 用连接查询.