sql組合查詢:多表查詢sql語句[朗讀]

用unionallselectinterid,sum(mobile)asmobilefrom(selectinterid,count(mobile)asmobilefrommobile1groupbyinteridunionallselectinterid,count(mobile)asmobilefrommobile2groupbyinterid)agroupbyinteridorderbyinterid。