0
I have 2 tables, one contains the number of links of all my clients, in another I have the spreadsheet that contains all the registered calls of 1 of my clients, registered by several analysts. These analysts are in the 2 tables, the client also, but I can not display in a table the number of calls received by that client and the number of calls, example:
| analyst | links | called |
|---|---|---|
| Jose | 12 | 15 |
| Maria | 10 | 20 |
The language I used is SQL, these spreadsheets are in a Dashboard applications that calls Zoho, I’m still beginner in sql language, only knew how to select the first table
SELECT "ANALYSTS", "DATA" FROM "CALLED" and so on