Update from Select Query
Update from Select Query
update "subscriptionDetails" set status ='active'
from (
select t."id" from tenants t where t."senderEmail" in ('imprezzdev+ravinder@gmail.com' )
) as "t" where "t"."id" = "tenantId"
update "subscriptionDetails" set status ='active'
from (
select t."id" from tenants t where t."senderEmail" in ('imprezzdev+ravinder@gmail.com' )
) as "t" where "t"."id" = "tenantId"