UNION函數

連接函數

SELECTA1. ID,A1.TEST_OBJECT_ID,BIZ_ITEM_ID,BIZ_ITEM_TYPE,A2.ASSAY_ITEM_NAME BIZ_ITEM_NAME FROMDIC_ASSAY_BUSINESS_ITEM A1,DIC_ASSAY_ITEM A2 WHEREA1.BIZ_ITEM_TYPE = 2 AND A1.BIZ_ITEM_ID = A2. ID AND A1.TEST_OBJECT_ID = A2.TEST_OBJECT_ID UNIONSELECTB1. ID,B1.TEST_OBJECT_ID,BIZ_ITEM_ID,BIZ_ITEM_TYPE,B2.BIZ_TASK_NAME BIZ_ITEM_NAMEFROMDIC_ASSAY_BUSINESS_ITEM B1,DIC_BUSINESS_TASK B2WHEREB1.BIZ_ITEM_TYPE = 3AND B1.BIZ_ITEM_ID = B2. IDAND B1.TEST_OBJECT_ID = B2.TEST_OBJECT_ID

注意
Union兩邊的列數，必須一致

總結

以上是生活随笔為你收集整理的Oracle的UNION函数的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。