假设我有2个这样的表：

工作邀请：

+----+------------+------------+
| ID |    Name    | Categories |
+----+------------+------------+
|  1 | Programmer | 1,2        |
|  2 | Analyst    | 3          |
+----+------------+------------+

分类：

+----+-----------------+
| ID |      Name       |
+----+-----------------+
|  1 | Programming     |
|  2 | Web Programming |
|  3 | Analysis        |
+----+-----------------+

我们有一个字符串拆分，它接受一个字符串，一个定界符并返回一个表，我的问题是我真的不确定如何将表集成到查询中以加入工作机会和类别。

我的想法是这样的：

SELECT
    O.[ID]                  AS OfferID,
    O.[Name]                AS OfferName,
    CAT.[CategoryName]      AS CategoryName,
    CAT.[CategoryID]        AS CategoryID
FROM
    JobOffers AS O
LEFT JOIN
(
    SELECT 
        O.[ID]              AS OfferID,
        C.[CategoryID]      AS CategoryID,
        C.[Name]            AS Name
    FROM
        (
            SELECT *
            FROM [dbo].[Split](O.[Categories], ',')
        ) AS CJ
    LEFT JOIN
        [Categories] AS C
        ON C.CategoryID = CJ.items  
) AS CAT ON CAT.OfferID = O.[ID]

目前，我有两个错误的说法：

• multi-part identifier O.[ID] cannot be bound
• multi-part identifier O.[Categories] cannot be bound
• incorrect syntax near AS （最后一行）

显然，问题是我如何构造子查询。