视图中使用"UNION"的方法

最新推荐文章于 2024-04-13 17:45:00 发布

原创最新推荐文章于 2024-04-13 17:45:00 发布 · 3.3k 阅读

1 ·

CC 4.0 BY-SA版权

java 专栏收录该内容

31 篇文章

订阅专栏

SELECT TOP 100 PERCENT *
FROM (SELECT indexid, sentfrom, subject, senttime, msgsize, username, istrash,
              2 AS folderType, hasattachment, uid
        FROM jmOutbox
        WHERE istrash = 1
        UNION
        SELECT indexid, sentfrom, subject, senttime, msgsize, username, istrash,
              1 AS folderType, hasattachment, uid
        FROM jmInbox
        WHERE istrash = 1
        UNION
        SELECT indexid, sentfrom, subject, senttime, msgsize, username, istrash,
              3 AS folderType, hasattachment, uid
        FROM jmDraftbox
        WHERE istrash = 1) temptable
ORDER BY senttime DESC