I have two data sources.
One is a mongo which shows agentID, policyID and some details of the policy.
The other is mysql where I have the agentID again and the details of the agent like name, email, etc.
select agentID, name, email from agentRecords where agentID='';
How do I join the two and create a table so that I can show the agent data and the policy data when the agentID is the criteria to join the two data sets. I could create a table of the mongo data and get the selectedrow.data and pass that on to the mysql query but that's not what I want.