We have Azure sql db and Azure sql managed instance (for db migrated from on-premise sql server).
I want to query tables of managed instance from Azure sql db through a stored procedure using joins.
Is this valid and possible scenario? How this can be achieved?
Thanks in advance!