> SELECT a.id, a.name, b.deptid, ... FROM table1 AS a, table2 AS b
  WHERE a.id = b.id;
# 或者
> SELECT a.id, a.name, b.deptid, ... FROM table1 join table2
  ON table1.id = table2.id;