萌新！mysql多表查询

Question

问题描述现在有两个表a,ba表数据有team,master,slave,time(团队,成员1，成员2，时间)b表数据有team,user,code(团队,成员,代号)其中a表成员1，成员2与b表中user对应相关代码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;结果是:teammastermaster_codetimecs小明000012019-07-31teamslaveslave_codetimecs大明000022019-07-31你期待的结果是什么？实际看到的错误信息又是什么？现在我想把这两个sql结果合并成一个teamslaveslave_codemastermaster_codetimecs大明00002小明000012019-07-31

Answer 1

SELECT*FROMaleftjoinbona.master=b.userleftjoinbcona.slave=c.user