查询多张没关联的表的数据

最新推荐文章于 2024-09-20 16:36:00 发布

原创最新推荐文章于 2024-09-20 16:36:00 发布 · 2.9k 阅读

0 ·

CC 4.0 BY-SA版权

Oracle 专栏收录该内容

4 篇文章

订阅专栏

1，查询多张没关联关系的表的数据

SELECT APPLY_UNIT FROM ((SELECT APPLY_UNIT FROM OFFICE_ROOM_APPLY WHERE STATE != 3 AND STATE != 5) UNION ALL (SELECT APPLY_UNIT FROM OFFICE_ROOM_RETURN WHERE STATE != 3 AND STATE != 5) UNION ALL (SELECT APPLY_UNIT FROM OFFICE_ROOM_SERVICE WHERE STATE != 3 AND STATE != 5))