1. To retrieve all active customer names and tenant id
select id,tenant_name from tenant where id in(select id from msa where msa_end_date >=now())
***********************************************************************************************************************************
2.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article