UPDATE T1
SET T1.size = (SELECT COUNT(DISTINCT T2.id) FROM T1 FULL OUTER JOIN T2 ON T1.address = T2.address)
WHERE ((SELECT strftime('%s','now')) - T1.Time) >86400
AND T1.status = 'Pending'
Could someone point out why this isn't working?
T1 schema: (id, address, time, size, status), T2 schema: (id, address, time)
from Recent Questions - Stack Overflow https://ift.tt/3eFKENu
https://ift.tt/eA8V8J
No comments:
Post a Comment