MySQL DELETE Query с производной таблицей

Question

Добрый день всем.

Я застрял на MySql удалить запрос.

В основном мне нужно удалить результаты этого SELECT запрос:

SELECT radcheck.* FROM
(SELECT
  permanent_users.realm,
  devices.name,
  devices.created,
  TimeDiff(Now(), devices.created) AS TimeDifference
FROM
  permanent_users
  INNER JOIN devices ON devices.permanent_user_id = permanent_users.id
WHERE
  TimeDiff(Now(), devices.created) > '01:30') MySubQuery
  INNER JOIN radcheck ON MySubQuery.name = radcheck.username

Любая помощь будет высоко ценится!

Спасибо

Answer 1

Должно быть

  delete radcheck from radcheck
  inner join  (SELECT
      permanent_users.realm,
      devices.name,
      devices.created,
      TimeDiff(Now(), devices.created) AS TimeDifference
    FROM
      permanent_users
      INNER JOIN devices ON devices.permanent_user_id = permanent_users.id
    WHERE
      TimeDiff(Now(), devices.created) > '01:30') MySubQuery on MySubQuery.name = radcheck.username

Answer 2

Следуя подсказке scaisEdge, это работает

БЛАГОДАРЮ ВАС!!

delete radcheck from radcheck
  inner join  (SELECT
     permanent_users.realm,
     devices.name,
     devices.created,
     TimeDiff(Now(), devices.created) AS TimeDifference
  FROM
     permanent_users
     INNER JOIN devices ON devices.permanent_user_id = permanent_users.id
  WHERE
     TimeDiff(Now(), devices.created) > '00:05') MySubQuery on MySubQuery.name = radcheck.username;