T-SQL FROM子句语法错误排查请求

首先看你的SQL报错是FROM子句语法错误，主要有两个关键问题：

1. 重复的关联条件：你在FROM子句里重复写了ON Parts.ID = ToolParts.PartID，这会导致数据库解析时混淆关联逻辑。
2. 过度复杂的括号嵌套：多层嵌套的括号让SQL结构混乱，不仅容易写错，也不利于排查问题。

接下来我帮你整理并修正了SQL代码，调整了JOIN的结构，去掉了重复的条件，同时保持原有的关联逻辑：

SELECT 
    ToolLists.Ident,
    ToolLists.Descript AS TLDescript,
    ToolLists.MaterialNr,
    ToolLists.Order,
    ToolLists.Who,
    ToolLists.NCP,
    ToolLists.Rem AS TLRem,
    ToolLists.MDate,
    ToolLists.TDate,
    ToolLists.GDate,
    ToolList.T,
    Machines.Name AS MachineName,
    Machines.TRelation,
    ToolList.D,
    ToolList.H,
    ToolList.Pos AS ToolListPos,
    ToolList.Rem AS ToolListRem,
    ToolList.How AS ToolListHow,
    Tools.Nr,
    Tools.Z1,
    Tools.Drawing,
    Tools.X1,
    Tools.Sort,
    Tools.Design,
    Tools.Descript,
    Tools.Rem AS ToolRem,
    ToolParts.Pos AS ToolPartPos,
    ToolParts.Nbr,
    ToolParts.How,
    Parts.UNr,
    Parts.MID,
    Parts.Descript,
    Parts.Sort,
    Parts.Design,
    Parts.URem,
    Parts.DMC,
    Parts.CLength,
    Parts.CMainArc,
    Parts.CRadius,
    Parts.UActiv,
    MatClasses.DMC,
    MatClasses.Description,
    MatClasses.Quality,
    NoteParts.NoteText,
    SP.Place
FROM 
    (SELECT ID, Param1 FROM WTDIDList WHERE WTGUID = '8c68ba58-5ad5-4a13-9bd4-0c4d1109d7c8') AS IDList
INNER JOIN ToolLists ON IDList.ID = ToolLists.Nr
INNER JOIN Materials ON Materials.Nr = ToolLists.MaterialNr
INNER JOIN MatClasses ON MatClasses.Nr = Materials.MatClassNr
INNER JOIN ToolList ON ToolLists.Nr = ToolList.ToolListNr
INNER JOIN Tools ON Tools.Nr = ToolList.ToolNr
LEFT JOIN Machines ON Machines.Nr = ToolLists.MachineNr  -- 等价于原RIGHT JOIN逻辑，写法更直观
INNER JOIN ToolParts ON Tools.Nr = ToolParts.ToolNr
INNER JOIN Parts ON Parts.ID = ToolParts.PartID
INNER JOIN NoteParts ON ToolParts.PartID = NoteParts.Nr
LEFT JOIN (SELECT PartId, Place FROM SiteParts WHERE SiteNr = 1) AS SP ON SP.PartId = Parts.Id
ORDER BY 
    ToolLists.Nr, 
    ToolList.Pos, 
    ToolList.T;

调整说明： #

• 把嵌套的JOIN拆成线性结构，更易读和维护，数据库解析起来也更清晰。
• 去掉了重复的ON Parts.ID = ToolParts.PartID条件，这个只需要在Parts和ToolParts关联时写一次。
• 把原有的Machines RIGHT JOIN (...)改成(...) LEFT JOIN Machines，逻辑完全一致，但写法更符合常规的从左到右关联习惯，减少混淆。
• 格式化了SELECT和FROM子句，让每个字段和表关联都单独一行，方便你后续修改和排查问题。

你可以运行修正后的代码，应该能解决FROM子句的语法错误。如果还有其他问题，可以再看具体的报错信息进一步调整。

内容的提问来源于stack exchange，提问作者Daniel Santos