relation.txt

来自「数据库连接查询」· 文本 代码 · 共 17 行

SELECT [t0].[CategoryID], [t0].[CategoryName], [t1].[BoardID], [t1].[BoardName], [t1].[BoardCategory], (
    SELECT COUNT(*)
    FROM [Boards] AS [t3]
    WHERE [t3].[BoardCategory] = [t0].[CategoryID]
    ) AS [count]
FROM [Categories] AS [t0]
LEFT OUTER JOIN [Boards] AS [t1] ON [t1].[BoardCategory] = [t0].[CategoryID]
WHERE ((
    SELECT COUNT(*)
    FROM [Boards] AS [t2]
    WHERE [t2].[BoardCategory] = [t0].[CategoryID]
    )) > @p0
ORDER BY [t0].[CategoryID], [t1].[BoardID]
-- @p0: Input Int32 (Size = 0; Prec = 0; Scale = 0) [2]
-- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.20706.1