mysql三张表关联查询答:---table1指的是第一张表,table2指的是第二张表,table3指的是第三张表,select a.uid,a.uname,a.upsw,a.urealname,a.utel,a.remark,b.rname,b.rremark,c.deptname,c.deptremark from table1 a,table2 b, table3 c where a.sems_role_rid=b.rid and a.udeptid=c.deptid ...
mysql中a,b,c三个个表主键相同 连表查询 只显示a表的主键答:select a.id,name,sex,address,tel,info,uk,ip,time from a left join b on a.id=b.id left join c on a.id=c.id