发布于

关联表聊连表统计条数

方法一：

SELECT
  COUNT(*)
FROM
  zn_supervise_state AS a
INNER JOIN (
  SELECT
    id
  FROM
    sys_organization
  WHERE
    sys_organization.id = '7'
  OR sys_organization.parent_id = '7'
) AS b ON a.organization_id = b.id

方法二：

SELECT
  COUNT(*)
FROM
  zn_supervise_state
WHERE
  zn_supervise_state.organization_id IN (
    SELECT
      id
    FROM
      sys_organization
    WHERE
      sys_organization.id = '7'
    OR sys_organization.parent_id = '7'
  )