Using SQL Server 2008 Management Studio
Table 1: MasterAccounts
PK MasterAccount_ID int
Table 2: LeadSourceProviders
PK LeadSourceProvider_ID int
the result I am looking for is as follows (when executing the sql script) :
LeadSourceProviderName, [count of Master Accounts using that LeadSourceProviderName)
LeadSourceProviders has a 1-to-Many relationship with MasterAccounts table.
How would you construct a SQL query to do this please?