Skip to content

Instantly share code, notes, and snippets.

@gmwill934

gmwill934/subselect.sql

Created December 31, 2021 00:55
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save gmwill934/02feaed367c49283dae4c82750d15404 to your computer and use it in GitHub Desktop.
Save gmwill934/02feaed367c49283dae4c82750d15404 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
subselect.sql
update public."User"
set "isVerified" = true
where "id" = (
select
u."id"
from
public."User" as u
join public."Tenant" as t on t."id"=u."tenantId"
join public."TenantMeta" as tm on t."id"=tm."tenantId" and tm."token" = '')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment