Join two tables with similar columns

Question

I hva two tables as is:

Now, I would like to be able to have the total commissions generated by Jhon and Tony's clients, a bit like:

commercials	commissions
Jhon	33
Tony	14

The only element that links the univers table and the transactions table are the customer IDs, namely their names, nothing else.

How can I proceed please? THANKS.

score 2 · Accepted Answer · answered Jun 14 '23 at 18:24

2

SELECT t1.commercial, SUM(t2.commission) commissions
FROM univers t1
JOIN transactions t2 ON t1.client IN (t2.frclient, t2.toclient)
GROUP BY 1

answered Jun 14 '23 at 18:24

Akina

1 Answers1