問(wèn)題描述現(xiàn)在有兩個(gè)表a,ba表數(shù)據(jù)有team,master,slave,time(團(tuán)隊(duì),成員1，成員2，時(shí)間)b表數(shù)據(jù)有team,user,code(團(tuán)隊(duì),成員,代號(hào))其中a表成員1，成員2與b表中user對(duì)應(yīng)相關(guān)代碼selecta.team,a.master,a.time,b.codeasmaster_codefroma,bwherea.timelike'2019-07-31'anda.master=b.user;selecta.team,a.slave,a.time,b.codeasslave_codefroma,bwherea.timelike'2019-07-31'anda.slave=b.user;結(jié)果是:teammastermaster_codetimecs小明000012019-07-31teamslaveslave_codetimecs大明000022019-07-31你期待的結(jié)果是什么？實(shí)際看到的錯(cuò)誤信息又是什么？現(xiàn)在我想把這兩個(gè)sql結(jié)果合并成一個(gè)teamslaveslave_codemastermaster_codetimecs大明00002小明000012019-07-31