SELECT staffstaffid staffstaffname branchbranchname deptdeptname branchsnewbranch branchsnewdepartment branchstime branchsapplicant branchsdatetime branchsreviewedby branchsstate 生成一个多表联查

SELECT staff.staffid, staff.staffname, branch.branchname, dept.deptname, branchs.newbranch, branchs.newdepartment, branchs.time, branchs.applicant, branchs.datetime, branchs.reviewedby, branchs.state FROM staff JOIN branch ON staff.staffid = branch.staffid JOIN dept ON staff.staffid = dept.staffid JOIN branchs ON staff.staffid = branchs.staffid