27,579
社区成员
发帖
与我相关
我的任务
分享
SELECT [Card].[cardTitle] AS [Title],[Card].[content] AS [content],[Card].[deliveTime] AS [deliveTime], [User].[userName] AS [userName]
FROM [Card] inner join [User] on [Card].[userID] = [User].[userID]
WHERE [Card].[cardID]=1
UNION ALL
SELECT [Reply].[replyTitle] AS [Title],[Reply].[content] AS [content],[Reply].[deliveTime] AS [deliveTime],[User].[userName] AS [userName]
FROM [Reply] inner join [User] on [Reply].[userID] = [User].[userID]
WHERE [Card].[cardID]=1
ORDER BY [Reply].[deliveTime]
up..