Look at my SQL. I would not know how to do something similar with wixData. I need to join data from 2 tables/collections. Thank you!
let mySQL = 'SELECT Agent.commissionsDisplayName, Agent.displayName, Commissions._id, '
mySQL += 'Commissions.date, Commissions.payeeEmail, Agent.email, Commissions.policy, '
mySQL += 'Commissions.clientFirstName, Commissions.clientLastName, Commissions.type, Commissions.amount '
mySQL += 'FROM Commissions '
mySQL += 'INNER JOIN Agent ON Commissions.payeeEmail = Agent.email