作者查詢 / Hanakun
作者 Hanakun 在 PTT [ Database ] 看板的留言(推文), 共3則
限定看板：Database
看板排序：
全部Mo-Musume495japanavgirls128EZsoft96joke52GURUGURU31Emulator30YUI28AVEncode27Storage_Zone27Taoism27ATASHInCHI17PHP15Tainan13creditcard12P2PSoftWare12movie10Army-Sir8Crowd8Blog7GONZO7Gradol7share7Android6Arti53-2t6Free_box6Google6HSNU_8826NTPU-JLAW946ArakawaCow5drawing5ikimono5NHU_Talk5AC_Sale4GatoShoji4Gossiping4ntnuHE954SYSOP4Bank_Service3Comic3Database3HSNU_10083MobilePay3NIUECE913NTUot943SpaceArt3XiangSheng3BBSmovie2Broad_Band2Browsers2C_Question2ck57th3202CSMU-LS892CSMU-MED932e-coupon2HardwareSale2Hate2HCHS923162HTSH-7th3132ID_Problem2J-PopStation2KERORO2KS87-3022KS93-3162KS94-3202NCCU05_ITMBA2NLHS-3th-3062NTHU_STAT942NTUCH-902PCman2PlayStation2S.H.E2TA_AN2TKU-ChemSB2TTU-I91A2TTV2AC_Music1ArabicBasket1AudioPlayer1ayaka1BCC_Midnight1Beauty1Buzz_Act1CCJH-89g-3141CD-R1Cga1Chan_Mou1Chen_C_H1ck55th3251ck55th3321ck56th3141ck57th3151ck58th3071cksh80th3071cksh82nd3041cksh82nd3081CLUB_KABA1CSMU-AC921CSMU-MED941CSMU-OT941CSMU-SG1CTSH933031CYCU_EE_07A1CYCU_MIS_93A1DeathNote1Eco_Tennis1Emergency1FCU-PF20061FinalFantasy1FISH-FRIEND1FJU-ACC93a1FJU-AM-901FJU-Law20071FJU-Laws921FJU_Chiayun1FJU_PSY0941FuHo14th3431HDFS_Bball1Health_Life1HGSH543111HSNU_10091HSNU_10851HSNU_9891JapanMovie1Jay1JP_Entertain1katsura1KS92-3031KS93-3041KS94-3071KS94-3121KS94-3131KS95-3151KS_PMAC1Lifeismoney1LifeSci_921LT90_3091MABADMINTON1MKSH50th3061mobile-game1MP_53-2T1MUSTMIS1MyCIA1NCCU04_ITMBA1NCCU04_TUR1NCCU05_DIP1NCCU05_HISTO1NCCU_Fantasy1NDHU-ChBb1NDHU-dc971NDHU-DSLS071NDHU-DSLS081NDHU-phy971NDMC-D611NDMC-D621NDMC-M1031NDMC-N561NDMC-PH241NIUEE93a1NKNU_OECE971NTCU-SPE92A1NTHU-EE-CAPT1NTHU-MSE091NTPU-ACC901NTPU-ECONM931NTUAC941NTUCE-961NTUCH-991NTUDancing1NTUDFLL-VBT1NTUE_Nse961NTUEE_VAL1NTUHorti951NTUMSE-941PttHistory1PushDoll1R923220PA1SC-91-3011SCU_CIS-92A1SSSH-03rd3111Stella1Taurus1theshine41THU_PH901TKU-IE941Toko_IT_1st1TS_Best_3031TTU-I90B1Turkiyesporu1VET_941VibWang1WRADPE1WuLing46-3171WuLing48-3111YP91-3111YP92-3041YP93-3041Yup01-041<< 收起看板(197)
首頁
上一頁
1
下一頁
尾頁
1F→:問題已經自行解決了 方法是把這兩個搜尋個別建view01/12 22:13
2F→:然後再去對這兩個view以LEFT JOIN方式找出非共有的資料01/12 22:13
3F→:原本用MINUS就可以做到的功能 只可惜MySQL就是不支援...01/12 22:13
首頁
上一頁
1
下一頁
尾頁