Skip to Content
0
Former Member
Aug 05, 2016 at 05:57 PM

Results from different tables in one line

27 Views

Hello everyone,

I am trying to figure out the best way to do this but I am not quite sure.

I have three tables, "Lead", "Account", and "Opportunities."

What I am trying to do is show a count of how many Accounts and Opportunities were created (each table has a create date) that matches the Lead, so something like this:

-----------Account-----Opportunity

Lead1: 1 2

Lead2: 2 3

Lead3: 1 1

Something like that. The Account and Opportunity tables each have a LeadSourceID that matches with the Lead table.

Any suggestions??