mysql - Sql union 操作
問題描述
問題：第一種寫法：
(select du.day,du.apptoken ,du.version, du.channel,du.city,du.count,concat(apptoken, version,channel,city) as joinkey from day_new_users_count du where day=’20170319’) as dayUsers union (select tu.day,tu.apptoken,tu.version,tu.channel,tu.city,tu.count,concat(apptoken,version,channel,city) as joinkey from total_users tu where day=’20170318’) as toUsers
第二種寫法：
select du.day,du.apptoken ,du.version, du.channel,du.city,du.count,concat(apptoken, version,channel,city) as joinkey from day_new_users_count du where day=’20170319’ union select tu.day,tu.apptoken,tu.version,tu.channel,tu.city,tu.count,concat(apptoken,version,channel,city) as joinkey from total_users tu where day=’20170318’
為什么第二種寫法可以正確執行，第一種方式就不可以？？
區別 不是 第一種方式中給 臨時表起了個別名嘛，怎么就不行了？高人指點吶
問題解答
回答1：select * from (selectdu.day, du.apptoken , du.version, du.channel, du.city, du.count,concat(apptoken, version,channel,city) as joinkeyfrom day_new_users_count duwhere day=’20170319’) as dayUsersunionselect * from (selecttu.day, tu.apptoken, tu.version, tu.channel, tu.city, tu.count,concat(apptoken,version,channel,city) as joinkeyfrom total_users tuwhere day=’20170318’) as toUsers
相關文章：
1. javascript - 百度echarts series數據更新問題2. Mysql && Redis 并發問題3. css3 - css before 中文亂碼？4. php - 第三方支付平臺在很短時間內多次異步通知,訂單多次確認收款5. javascript - 請問一下組件的生命周期beforeDestory是在什么情況下面觸發的呢？6. mysql - 一個表和多個表是多對多的關系，該怎么設計7. javascript - 請教空白文本節點的問題8. javascript - 父選項卡bug，子選項卡好用，求解？9. javascript - node服務端渲染的困惑10. mysql新建字段時 timestamp NOT NULL DEFAULT ’0000-00-00 00:00:00’ 報錯
網公網安備