ai-agents-view-creation-hetero-need-to-join-data-from-different-data-systems-e-g--0fd8545b

THEN Create a SQL view that joins tables from different sources, even if they are of different types (document DB and relational), using MindsDB's `CREATE VIEW` statement.

CREATE VIEW risky_renewals AS (SELECT * FROM mongodb.support_tickets AS reviews JOIN salesforce.opportunities AS deals ON reviews.customer_domain = deals.customer_domain WHERE deals.type = 'renewal' AND reviews.sentiment = 'negative');