SELECT staffstaffidstaffstaffnamedeptdeptnamebrnewbranchbrnewdepartmentbrtimebrapplicantbrdatetimebrreviewedbybrstate 生成多表联查

SELECT staff.staffid, staff.staffname, dept.deptname, br.newbranch, br.newdepartment, br.time, br.applicant, br.datetime, br.reviewedby, br.state FROM staff INNER JOIN dept ON staff.deptid = dept.deptid INNER JOIN br ON staff.staffid = br.staffid